Using calculation groups in DAX

Рет қаралды 20,156

Күн бұрын

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

Пікірлер: 20

@markhenderson3771 2 жыл бұрын

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.

@SQLBits 2 жыл бұрын

Thank you, Mark!

@pupycron4302 Жыл бұрын

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!

@SQLBits Жыл бұрын

Glad you liked it, that's lovely feedback!

@DeronHuskey 2 жыл бұрын

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.

@SQLBits 2 жыл бұрын

Great to hear!

@gueszka 3 жыл бұрын

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?

@edsonteixeira6057 Жыл бұрын

THANK YOU..SHOW SHOW SHOW..

@Psyresidente 2 жыл бұрын

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 !

@SQLBits 2 жыл бұрын

Hey, it's worth sending Alberto a message via twitter/linkedin as that is where they are most active!

@bandaralqahtani4356 2 жыл бұрын

Thanks, Alberto, do you have workshops only for DAX functions and hands-on projects?

@SQLBits 2 жыл бұрын

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!!)

@DavidPesante Жыл бұрын

Is there a video like this but for how to use the new Field Parameters feature in DAX?

@DavidPesante Жыл бұрын

In specific with dimension type columns so that we can use statements like ALLSELECTED or REMOVEFILTERS

@schenas 2 жыл бұрын

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 ?

@renusharmadhoundiyal Жыл бұрын

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.

@Kenayi22 Жыл бұрын

Hi Alberto, which of your Udemy courses correctly represent your green Business Analysis Book on Amazon please? I plan to buy both

@SQLBits Жыл бұрын

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!

@user-eg6tr4tn8b 6 ай бұрын

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?

@SQLBits 6 ай бұрын

Hi, you can get in touch with the speakers directly through LinkedIn and X! They are normally more than happy to help.