Removal of today's data from the data set

[Anonymous]

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

[johnt75]

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]

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

Actually below is my calender table