Dynamic Date Range Slicer Using A Period Table For Your Power BI Report

Dynamic Date Range Slicer Using A Period Table For Your Power BI Report

Enterprise DNA

3 года назад

23,051 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@shivaniverma3324
@shivaniverma3324 - 02.06.2021 12:27

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.

Ответить
@akhilreddy8220
@akhilreddy8220 - 09.01.2021 19:19

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

Ответить
@michaelmurgado6911
@michaelmurgado6911 - 15.10.2020 12:57

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

Ответить