cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arunhariharan
Frequent Visitor

dax to create measure for calculating PPM for last year last 3 months data

Spoiler
Hi  Team

I am having data for Region, OpenDate and PPM Measure for the months starting from Oct 2020 till Jul 2021
PPM Measure = sum(qty rjctd)/sum(qty rcvd) * 1000000
I need to calculate the last year last 3 month  PPM Measure using DAX basically for the month of April, May , June 2020 the corresponding PPM Measure values
Currently there is no data for the months of April, May, June 2020 i.e. there is no Opendate for the month of Apr , May . June 2020 . As a result I am not getting data for these months . So Is it possible to show the data for Apr, May and June 2020 as 0 instead of blank. I am trying to create matrix report with Open Date Month in the columns , region in the rows and PPM Measure in the values. In the matrix report I am unable to see the data for the Open Date Month of Apr , May and June 2020
When I select the show items with no data then it is displaying values for Oct , Nov , Dec 2020 , Jan 2021 till Jul 2021. However I dont find Apr, May and June 2020 in the Open Date Month column

Regards
Arun


1 REPLY 1
amitchandak
Super User
Super User

@arunhariharan , Last year last three months rolling

Rolling 3 lasy year= CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date ]),-13),-3,MONTH))

 

or

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors