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 have a set of data which requires a growth calculation by month - like jul/jul, aug/aug etc. and then like this jul/jul, jul+aug/jul+aug, jul+aug+sep/jul+aug+sep.
I have written two sets of DAX formulae as below :
1. The formula below is calculating the MOM alright
2. But when I am trying to get a cumulative moving total with this formula below , it is not producing the intended result
3. The onedrive link to the file, for anyone interested to dig....
https://1drv.ms/u/s!Ap6x08u38fPyezXp1mgNp2CSigY
any help appreciated
regds.,
Hi @chakrabmonoj,
The syntax is correct, but it points to day level, and you use Dates[Date]<=max(Dates[Date]) in the formula, if you select the Dates[Date] as row level, it shows correctly as follows.
Then Dates month is calculated by [previous] and [Date], it is not recognized size. When you select it as row level, which is uncorresponding to date, so you get wrong result.
In addition, what's your requirement, could you please post an example?
Best Regards,
Angelia
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |