Calculate sum of qty in different timeperiods in relation to my slicer

[Anonymous]

Hi

I need to create a measure that calculates my qty in different time periods. 

The periods should relate to which yearmonth i chose in my slicer. 

The periods are as follows: 0-6 month, 6-12 months, 12-24 months and >24 months

Anybody who can help me with the DAX to create this/these measures? 

[amitchandak · Accepted solution]

@Anonymous , Create these values in an independent table and handle and switch .

Measure you need are

Rolling 6 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-6,MONTH))

Rolling 6 to 12  = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date ]),-6),-6,MONTH))

Rolling 12 to 24  = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date ]),-12),-12 ,MONTH))

create slicer as we do in measure slicer

refer

https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-30/m-p/1284966#M561629

How to create a Measure Slicer: https://youtu.be/b9352Vxuj-M