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