Forum Discussion

AVIE's avatar
AVIE
Frequent Visitor
5 years ago
Solved

Measure total of difference

Dear,   I can't share my data source due to confidentiality, but I'm struggling to get the sum of all differences shown correctly in a measure.    Source data: Delivery period Economical per...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    AVIE , Try diff like

    Diff = SUMX(VALUES('Date'[Period]),if(not(ISBLANK([Prior Value])) && not(ISBLANK([Total value])),[Total value] -[Prior Value],BLANK()))
AVIE's avatar
AVIE
Frequent Visitor
5 years ago

Thanks, amitchandak ! This works! I just have one question for my understanding - why do these formulas work when entering them in the dates table, and not when you enter them in the other table with all data?

AVIE's avatar
AVIE
Frequent Visitor
5 years ago

Dear amitchandak ,

Can you please reply to my last question above:

"I just have one question for my understanding - why do these formulas work when entering them in the dates table, and not when you enter them in the other table with all data?"

 

Also, is it possible to add a second measure that only takes account the "diff" of the first 2 months after the month in the delivery period. Example:

Delivery periodEconomical periodDifference2
January 2020January 20200
January 2020February 2020-20 
January 2020March 20200
January 2020April 20200
Total -20

So for delivery period January 2020, only the differences for February and March should show up for this measure, meaning the difference confirmed in April as in one of the posts above should be left out.

Thank you!