I'm new to Power BI, and I appreciate you sharing this so much. I've been having trouble with it for the past few weeks. Today, Yesterday, This Week, Last Week, This Month, Last Month, This Quarter, Last Quarter, This Year, Last Year, Custom are the exact requirements that I have. Would someone kindly share the logic for Today, Yesterday, This Week, and Last Week?

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.

Please note the function CreatePeriodTable does not match any available expression, Use Period instead.

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

@EnterpriseDNA

3 жыл бұрын

Hello Akhil Reddy, thank you for posting your query onto our channel. Well it's always a little bit difficult to judge and provide the results without looking at the data and working PBIX file. We encourage you to please write back to us onto our Community Forum by providing the working file so that our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping this helps you. Happy Learning!!! forum.enterprisedna.co/

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

@EnterpriseDNA

3 жыл бұрын

Hi Michael FinBI, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzread.info/dron/y2rBgj4M1tzK-urTZ28zcA.html