Did it happen to you that you have calculated a cumulative total (such as running total, or year to date, etc) either using the quick measures or by writing the DAX expression yourself, and then realizing that the calculation happens even for the periods without any real data? For example, you want to stop that calculation at a certain point in time. The trick is simple, in this video, I’ll explain how it works.
download the Power BI file and find the links to study more in my blog article here:
https://radacad.com/stopdaxcumulati...
*******************
Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.
RADACAD courses: https://learn.radacad.com
Become an academy member: https://learn.radacad.com/academy/
*******************
********
CONNECT with US!
********
/ radacad_com
/ rad_reza
/ leila_etaati
/ radacad
/ leilaetaatib0304636
/ rezarad
/ 6393399
https://radacad.com
********