In this tutorial, I’m going to show you a very simple technique where you can show data up to a specific date or just up to today inside of your Power BI reports.
This came from a recently requested question from the Enterprise DNA Support Forum, Personally, I’ve also used this technique many times so I know it is useful.
The reality is that the solution for this is much simpler than you may think. All you need to do is understand where the key locations are to set this up correctly.
Having a solid understanding of data modeling and why you need to set up your data model effectively is important here.
First, you need a date table. This is an essential part of any model but especially in this example.
Then within that date table, you need to add an additional column which becomes like an on/off switch in your report pages.
I walk you through this technique and also finally what you need to do inside of your report page with a specific filter to enable the data to visually only show up until a very specific date.
This is a combination of visualisation techniques with some simple DAX formula (in a calculated column).
Once all applied to your reports, you’ll likely see how seamlessly this works and at the same time how it can add value to your visuals.
If you need to learn how to set up an optimized date table within Power BI check out the below tutorial.
For further information on calculated columns in Power BI….
For more related tutorials around why a date table is so important to use for nearly every model you develop in Power BI, review the below links.
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – 60 Page DAX Reference Guide Download
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online
Enterprise DNA Events
***** Related Links*****
Show Days Before Or After A Selected Date Using Power BI
Normalizing Results On Different Days In Power BI Using DAX
Month to Date (MTD) To Today’s Actual Date In Power BI Using DAX
***** Related Support Forum Posts*****
Creating a Static Card
Current Week Calculation
How to showcase Budgets vs Actuals to today’s date
Find Date Of Last Result And Then Difference In A Data Table – Power BI
For more support queries on date related insights, click here….