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.
Hi,
I have the following measure:
Solved! Go to Solution.
HI @V-lianl-msft ,
Thanks for your answer!
I believe your measure works but the real problem is my dataset, which is realyy not structured for several reasons. I end up using the waterfall chart to do a cumulative sum over the month.
Thank,
Mikkel
Hi @Anonymous ,
Based on your description, there may be a column of date data in the table. The first condition is not to calculate from the first month .You can try a DAX similar to this:
Measure 2 = CALCULATE (Measure1,FILTER (table, 'Calendar'[Date] >MIN ( 'table'[Date] ) )
If you don't get the results you want, please provide some sample data so that we can help you more effectively.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI @V-lianl-msft ,
Thanks for your answer!
I believe your measure works but the real problem is my dataset, which is realyy not structured for several reasons. I end up using the waterfall chart to do a cumulative sum over the month.
Thank,
Mikkel
Hi @Anonymous,
It's glad that you have solved your problem.
Please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |