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...
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

aww91's avatar
aww91
Frequent Visitor
8 years ago

Any other ideas or suggestions? I have been working on this problem for a week. Thanks in advance.

Anonymous's avatar
Anonymous
Not applicable
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

  • aww91's avatar
    aww91
    Frequent Visitor
    8 years ago

    Outstanding! Works perfectly. Thank You.