Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
chakrabmonoj
Helper II
Helper II

month on month moving total cumulative and only for the month

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

 

 BI MOM code1.JPG

2. But when I am trying to get a cumulative moving total with this formula below , it is not producing the intended result

 

 

mom code 2.JPG

3. The onedrive link to the file, for anyone interested to dig....

 

https://1drv.ms/u/s!Ap6x08u38fPyezXp1mgNp2CSigY

 

any help appreciated

 

regds., 

 

 

 

 

 

 

1 REPLY 1
v-huizhn-msft
Employee
Employee

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.

1.PNG

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.