Mesure to filter time periods

Anonymous — Mon, 23 May 2022 20:45:13 GMT

Hello guys,

I think i had a solution here 1 year ago but i lost my pbix. Now trying to create it again.

I want to create a slicer in addition to slicers year-month.

In this slicer I want to have:

Month
YTD
previous 6 months
previous 12 months
Previous month
YTD Sameperiodlastyear
12 months for previous period

All proposed solutions on youtube give me the dax with Sum('Sales'[Ammount]) but I want to apply the periods to all different mesures without creating DAX for each one.

Now I'm creating my different sum mesures, than I will put in the new FieldParameter feature, and use this FieldParameter as "Sum('Sales'[Ammount])" in my timeperiods DAX, I could create a calculation group in Tabular editor but trial is finished.

However I'm sure there is a much more elegant and simple solution, all I need is just to filter the DateTable.

Thank you for any advice

Re: Mesure to filter time periods

amitchandak — Tue, 24 May 2022 06:53:41 GMT

Anonymous , calculation group is best in this case

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

topic Re: Mesure to filter time periods in DAX Commands and Tips

Mesure to filter time periods

Re: Mesure to filter time periods