Using calculation groups in DAX
Vložit
- čas přidán 30. 07. 2024
- This session introduces calculation groups, when they should be used and several examples of use cases. You will also learn how calculation groups work internally and what are the limits of this amazing tool.
Speaker: Alberto Ferrari SQLbits.com/speakers/Alberto_...
Speaker Blog: www.sqlbi.com
Speaker BIO: Alberto started working with SQL Server in 2000 and immediately his interest focused on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence.
SQLbits.com/Sessions/Using_cal...
Tags: Developing,On-prem,Cloud,Power BI,Power BI Embedded - Věda a technologie
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 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!
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!
THANK YOU..SHOW SHOW SHOW..
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?
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.
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!
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
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!
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.