Forum Discussion

aww91's avatar
aww91
Frequent Visitor
8 years ago
Solved

Diffence Report

Greetings,

Any help with this problem will be greatly appreciated. Trying to create a difference report and I am running into problems with displaying two summaries (Net Increase and Decreases). The report is intended to allow the user to select beginning and end dates from the dropdowns and to display summary and detail information (see screen shot). The problem is that I cannot seem to get the right filter context needed to display Increase and Decrease – the net change is displaying fine. Again, thanks in advance for any suggestions.

 

Below: Screen shot of expected report, and link to Power BI application (Google Drive)

Difference Report.pbix

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    aww91,

    Create the following measures in your Demand by Dates table.

    checkpositive = IF([SumEndDate]>[SumBegDate],[SumEndDate]-[SumBegDate],0)

    checknegative = IF([SumEndDate]<[SumBegDate],[SumEndDate]-[SumBegDate],0)

    Increase = IF(COUNTROWS(VALUES('Demand By Dates'[PPM ID]))=1, [checkpositive],SUMX(VALUES('Demand By Dates'[PPM ID]),[checkpositive]))

    Decrease = IF(COUNTROWS(VALUES('Demand By Dates'[PPM ID]))=1, [checknegative],SUMX(VALUES('Demand By Dates'[PPM ID]),[checknegative]))

    Regards,
    Lydia

5 Replies