Difference between periods

[LuciaS]

Hi!

I wanna calculate between periods by measure. 

Periods are 1.1,1.2  and i wanna calculate difference between periods of  products 1838 and 3262.

There will be new column between every period where will be calculated diferrence 

Thanks!

[v-yangliu-msft · Accepted solution]

Hi  @LuciaS ,

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

[Mahesh0016]

Hii @LuciaS can you share demo data for calculate between periods.