Forum Discussion

CJBoelt's avatar
CJBoelt
Frequent Visitor
3 years ago
Solved

How do I create a DAX calculating the change per sequence?

Here is a Example of what the new graph would be.   Essentially subtracting the actual_hours with all the values in the previous rows. This will provide a measure to show the difference of ch...
CALCULATE
DAX
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    =SUM(Table[[Total Actual hours])-CALCULATE(SUM(Table[[Total Actual hours]),TOPN(1,FILTER(ALLSELECTED(Table[SEQ]),Table[SEQ]<MAX(Table[SEQ])),Table[SEQ]))

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi CJBoelt ,

 

Please find below solution

Diff = SUM(Sheet1[Total Actual hours])- CALCULATE(SUM(Sheet1[Total Actual hours]),
OFFSET(-1,ALLSELECTED(Sheet1[SEQ]),ORDERBY(Sheet1[SEQ])))
 

 

Best Regards,
Shreya

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!