Difference between periods

Hi  Anonymous ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure =
var _current=
SUMX(
    FILTER(ALL('Table'),   'Table'[Flag]=MAX('Table'[Flag])&&'Table'[Group1]=MAX('Table'[Group1])&&'Table'[Group2]=MAX('Table'[Group2])),[Value])
var _next=
SUMX(
    FILTER(ALL('Table'),    'Table'[Flag]=MAX('Table'[Flag])&&'Table'[Group1]=MINX(FILTER(ALL('Table'),'Table'[Flag]=MAX('Table'[Flag])&&'Table'[Group1]>MAX('Table'[Group1])),[Group1])
    &&'Table'[Group2]=MAX('Table'[Group2])),[Value])
return
_current - _next

2. Result:

Best Regards,

Liu Yang

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