Show Results Up To Current Date Or A Specific Date In Power BI

One comment

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.

Results up to specific or last date Power BI

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.

Enterprise DNA support forum

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.

Calculate Column Power BI

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.

Page level filters Power BI

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.

Build A Comprehensive Date Table Really Fast in Power BI

For further information on calculated columns in Power BI….

Measures vs Calculated Columns – (1.4) Ultimate Beginners Guide to DAX

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.

Types Of Time Intelligence Functions – (1.15) Ultimate Beginners Guide to DAX

Month to Date (MTD) To Today’s Actual Date In Power BI Using DAX

Time Patterns For Power BI – 4 Examples Of Time Intelligence

Sam

***** 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

membership banner 3

***** 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 Course Modules*****
Mastering DAX Calculations
Time Intelligence Calculations
Advanced DAX Combinations

***** 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….

Enterprise DNA Events

1 comments on “Show Results Up To Current Date Or A Specific Date In Power BI”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.