cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Always 12 months Sum

HI All , 

How can i have the calculation of 12 months Sum ? as per below ? 1.jpg

 

Thanks with Regards, 
Leakna Hang 

1 ACCEPTED SOLUTION

Accepted Solutions
amitchandak Super Contributor
Super Contributor

Re: Always 12 months Sum

Try like this

 

Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date Filer],ENDOFMONTH(Sales[Sales Date]),-12,MONTH))  

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

View solution in original post

3 REPLIES 3
amitchandak Super Contributor
Super Contributor

Re: Always 12 months Sum

Try like this

 

Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date Filer],ENDOFMONTH(Sales[Sales Date]),-12,MONTH))  

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

View solution in original post

Re: Always 12 months Sum

@amitchandak , hi , thanks you for your response . anw i'd like to add another measure , 

recently i have a measure called : 12 Months Annual 2019

now i wanna add another measure called : 12 months Annual 2018 , 
Means , In Jan 2018 will be summed with Feb 2017 to Jan 2018

because i wanna do comparison between 12 months annual in 2019 and 12 months Annual in 2018. 

how to acheive this ?

amitchandak Super Contributor
Super Contributor

Re: Always 12 months Sum

@Chanleakna123 

Please use 12 before 12 like this

 

Rolling 12 before 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date Filer],ENDOFMONTH(dateadd(Sales[Sales Date],-12,MONTH)),-12,MONTH))

 

Once you choose a month in Slicer it should work

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)