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
