Skip to main content
cancel
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.

Reply
Anonymous
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

2 REPLIES 2
johnt75
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.

Anonymous
Not applicable

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

Rajesh_VR_1-1686309528167.png

 

Actually below is my calender table

Rajesh_VR_3-1686309566695.png

 

 

 

Helpful resources

Announcements
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.