Mesure to filter time periods

[Anonymous]

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

[amitchandak]

@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