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

Anonymous — Thu, 26 Aug 2021 08:30:19 GMT

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?

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

amitchandak — Thu, 26 Aug 2021 08:39:50 GMT

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

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