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

Good article, very well written however my situation is a little different. I am trying to sum separately positive and negative in the measure SumNetChg.

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.