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
