I could understand the calculate function better since its crystal clear explanation but I couldn't understand why this kind of excellent channel only have less than 1k subscribers. Guys please support it and I will recommend it to all my friends.
BRAVO !!! The best video to understand calculate and filter context. Thank you ! I have one question, all is the same as removefilters, so in order to override any filter we can simply use all(), could we use the same things with removefilters ??
Think someone is benefited out of this video even after 2 years of posting! I watched many videos to understand filter context and finally I arrived at the right place. Thanks a lot
Well done, Isabella 👍😁 Using a comparison of filtered and measures tables, side by side, was the best visual explainer that I've seen yet! I've seen a number of CALCULATE vids from different content creators, but this was definitely the most accessible and visually satisfying and enlightening. Many Thanks
Hello , can someone please tell me why even after mentioning the year as 2023 in calculate function we got values in 2022 column as well that too we got the values of year 2023 in the column 2022?
Sensacional tutorial on calculate superpowerful function and the filter context. Awesome break down and visual set up, turning the concept just easily digestable as taking breakfast in the morning. Bravo, Isabella, keep it up. Another way of dismytifying the concept is revealing what happens beyond the scrnes or under the hood, with the filter propagation from through the model relationship from tue dimension(lookup) tables, before the aggregation ou summarization of the filtered records takes places ou performed over the fact table). I really like the similarities with the sumifs() function and the superiority of calculate () over the sumifs() as given by its versatility, just making it all in one.
Hello... thanks for taking the time to leave some comments. I don't currently have a video on finance lease calculation. What type of calculation are you thinking of developing in PBI?
I am so happy got respond from you.. tqvm. I.m thinking of developing finance lease ammortization shcedule in power bi. Currently im struggle to calculate monthly finance lease liabilty for all my lease asset
One important remark from my side: CALCULATE in DAX/Power BI/Power Pivot, or SUMIF, VLOOKUP in Excel are NOT formulas, they are functions. It is a very big surprise to me to see so many experts (including Microsoft MVPs) that make confusion between a formula and a function. What would be your opinion ?
Hello Romulus... I didn't even know the difference between formula vs function, until I read you comments & did a bit of googling. Thank you for educating me. Seems like, if we are to be precise, everything should be called functions and formulas are only reserved for (+,-,*,/,%,^). Personally, I used both terms interchangeably. I often said something like... "Wao your formulas seems long & complicated". After all, we write formulas and functions in the same place in Excel, in the 'formula bar' in Excel. I wonder why Microsoft are not calling it the the 'function bar' ?
@@LighthouseAnalytix we cannot make this incredible confusion between functions and formulas. Microsoft Excel and other applications force us (if we are not already rigorous as we must be) to be exact and consistent in being exact. I would strongly recommend you to stop making this unacceptable mistake, because it creates confusion, and many people will learn and use these terms incorrectly. All your viewers will probably never question the correctness of your lectures, they simply trust you (and many other experts all over the Internet), so if you provide wrong information, they will use wrong information. Cheers and all the best !
I am fairly novice or newbie in the world of data analytics. There must be a tenue distinction in Excel betwee formula and Functions, the latter being predefined ot built in formulas, with or without arguments, and where we call and pass in the parameters. Some use parameters and arguments interchangebly. In programming language such as R and Python, the data analytics workflow revolves arround functions, be them built in, or user/customer defined. In fact function are generally grouped according to the category such as text/string, date and time, logic, aggregation , statistical, financial,........ Functions shine over the formulas because are reusable, avoid boring or tedious repetitive tasks.