Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Not applicable

Removal of today's data from the data set

Dear team,


As i am getting data from the data source at every day morning, i am able to make report still yesterday only.

In this case some of data may fall in today since the data is hitting the power bi at the morning

I just want to ignore that data (today's data) for below need


If I am applying Month wise filter, the data should show upto yesterday only
Can someone help me to achieve this?


Rajesh G

Super User
Super User

Add a new column to your date table,

Before Today = 'Date'[Date] < TODAY()

and then add that as a report level filter to only show when it is true.

Not applicable

While trying to wring that function my calender table is not showing in the suggestion drop down



Actually below is my calender table





Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.