Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculating Percentage Change

Hi,   I have a dataset similar to the below.   Date Job ID Job Hours Percentage Achieved 01/01/2022 1 100 10% 02/01/2022 1 100 20% 03/01/2022 1 100 50%   I need to cr...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Tahreem24's avatar
    Tahreem24
    4 years ago

    Anonymous Try this measure:

    Measure =
    VAR Prev_Row = CALCULATE(SUM('Table'[Percentage Achieved]),FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date])))
    VAR Diff_ = Prev_Row-SUM('Table'[Percentage Achieved])
    VAR Result = IF(Diff_=0,SUM('Table'[Percentage Achieved]),Diff_)
    RETURN Result

     

     

Tahreem24's avatar
Tahreem24
Super User
4 years ago

Anonymous Try this measure:

Measure =
VAR Prev_Row = CALCULATE(SUM('Table'[Percentage Achieved]),FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date])))
VAR Diff_ = Prev_Row-SUM('Table'[Percentage Achieved])
VAR Result = IF(Diff_=0,SUM('Table'[Percentage Achieved]),Diff_)
RETURN Result