Forum Discussion
Difference between periods
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!
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 - _next2. 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
2 Replies
Hii Anonymous can you share demo data for calculate 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 - _next2. 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
