Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to make a DAX measure such that for example in the next picture
For each month accumulate the month valor in the blue bar, for example in 2017-2 shows 1758 + 1782, in 2017-3 1758+1782+1792.
Actually the measure for the blue bar is a simple count, then i need some method to save the past moth value for this count (can be a calculated table, etc) to make this or i think that.
Thank so much for your help.
Hey,
without having more details about your data model (is there a dedicated Calendar Table and stuff like that) it's really hard to provide a proper solution.
I would give this a try
Acumulated Measure = CALCULATE( SUMX( FILTER( ALL('name of your facttable') ,'datetable'[datecolumn] <= MAX('datetable'[datecolumn]) ) ,[name of your measure] ) )
Maybe you will find some ideas on this side https://www.daxpatterns.com/ especially the part for date related calculations https://www.daxpatterns.com/time-patterns/
Hope this gives you some ideas
Regards
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |