Комментарии:
Thanks for this video
Can you please make this in Dax too, I want to now how to show the last 3 months, last 6 months ,last 9 months ,last 12 months on a slicer using Power bi dax.
Great Video. I have the same setup and an extra measure Last Year Sales. When I use the period slicer from this concept, the LY measure is blank. It works fine without the slicer. Please advice how can I approach to show Last Year values also while selecting the slicer
ОтветитьSeems like this would have been a good use case for Calculation Groups instead of all that M Code. Setup your fact data and then a calculation item for each time period filtering on the dates needed.
Then again maybe you started this project way before Calculation Groups were made available