This is excellent. The explanation of WHY things work how they work is not easy to come by. It helps to understand how to do things before I learn it wrong!
This was a very valuable video to me. Thank you for taking the time to explain the issues surrounding this feature. I'm looking forward to using this in my models.
Hi Alberto, I experienced much better performance with calculation groups instead of using switch with huge data models. I assume that switch evaluates all the nested measures but I haven't found any documentation to backup my thought. What do you think is there a significant difference in terms how the engine works with CG and Switch?
Hi Alberto, great explanation. In my case I would like to calculate MTD, QTD, YTD, Current and prev FISCAL YEAR... In all these that are not allowed to do it using time Intelligent cause the Fiscal YEAR starts in September. How is the best way to achieve this? I think I have an idea case In my calendar date table I have columns that identify those times with strings but I want to know if there is a easier way. Thanks !
I have 4 pricing type 12 sales total - Contract , Standard, buyin, Override. We want to see sales impact by price increase 1%, 1.5%, 2% and so on. but want to exclude buyin and override from calculating but they should return 12 sales total without any increase. So my total should be Contract , standard with price increase and Buying, override without price increase. I used calculate columns to use "If" and "switch"function but the result is not dynamic when i change % increase.
We had a wonderful training day session from Alberto at SQLBits this year '0 to DAX' I am sure he will be doing similar things elsewhere (or at SQLBits next year!!)
sarebbe bello poter vedere i tuoi video Alberto ferrari in lingua italiana complimenti per la tua professionalità esiste un corso fatto da te da acquistare su power bi in italiano ?
i have 1 calculation group for calculation Current season and last season. But when i apply 6 different measures into a matrix i want to get side by side net revenue current and last season/side by side room nights etc. it is possible to do this thing?
This is excellent. The explanation of WHY things work how they work is not easy to come by. It helps to understand how to do things before I learn it wrong!
Glad you liked it, that's lovely feedback!
Thank you for going into so much detail. I watched several other videos on calculation groups and yours dug a lot deeper. Great to see.
Thank you, Mark!
This was a very valuable video to me. Thank you for taking the time to explain the issues surrounding this feature.
I'm looking forward to using this in my models.
Great to hear!
Hi Alberto, I experienced much better performance with calculation groups instead of using switch with huge data models. I assume that switch evaluates all the nested measures but I haven't found any documentation to backup my thought. What do you think is there a significant difference in terms how the engine works with CG and Switch?
THANK YOU..SHOW SHOW SHOW..
Hi Alberto, great explanation. In my case I would like to calculate MTD, QTD, YTD, Current and prev FISCAL YEAR... In all these that are not allowed to do it using time Intelligent cause the Fiscal YEAR starts in September. How is the best way to achieve this? I think I have an idea case In my calendar date table I have columns that identify those times with strings but I want to know if there is a easier way. Thanks !
Hey, it's worth sending Alberto a message via twitter/linkedin as that is where they are most active!
I have 4 pricing type 12 sales total - Contract , Standard, buyin, Override. We want to see sales impact by price increase 1%, 1.5%, 2% and so on. but want to exclude buyin and override from calculating but they should return 12 sales total without any increase.
So my total should be Contract , standard with price increase and Buying, override without price increase. I used calculate columns to use "If" and "switch"function but the result is not dynamic when i change % increase.
Thanks, Alberto,
do you have workshops only for DAX functions and hands-on projects?
We had a wonderful training day session from Alberto at SQLBits this year '0 to DAX' I am sure he will be doing similar things elsewhere (or at SQLBits next year!!)
sarebbe bello poter vedere i tuoi video Alberto ferrari in lingua italiana complimenti per la tua professionalità esiste un corso fatto da te da acquistare su power bi in italiano ?
Is there a video like this but for how to use the new Field Parameters feature in DAX?
In specific with dimension type columns so that we can use statements like ALLSELECTED or REMOVEFILTERS
i have 1 calculation group for calculation Current season and last season. But when i apply 6 different measures into a matrix i want to get side by side net revenue current and last season/side by side room nights etc. it is possible to do this thing?
Hi, you can get in touch with the speakers directly through LinkedIn and X! They are normally more than happy to help.
Hi Alberto, which of your Udemy courses correctly represent your green Business Analysis Book on Amazon please? I plan to buy both
Hey, if you reach out to the speakers on LinkedIn/Twitter i'm sure they'll be able to answer any questions you may have!