cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Microsoft
Microsoft

Re: month on month moving total cumulative and only for the month

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
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors