Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |