Forum Discussion

Amir851's avatar
Amir851
Helper I
6 years ago

Calculate Row Difference between two consecutive rows based on two consecutive rows & other columns

Dear All,   I am trying to calculate row diff between two consecutive rows of Running Total % (which is Measure) based on two consecutive Rank All Machine (which is also Measure). Rank all Machine ...
Need Help
Tutorial Requests
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Amir851 ,

Maybe you can do like this:

rows_diff = 
CALCULATE(
    SUM([R_total]),
    FILTER(
        'Sales (3)',
        [Run_all] = EARLIER([Run_all]) + 1
    )
)



But, pay attention, my [R_total], [Run_all] , [rows_diff] are all calculated column.

I tried to do it by measures, but don't get it.

Hope the result is what you want.

 

Best regards,
Lionel Chen

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.