Hide value from previous day(s)

[Anonymous]

Hi there,

I am searching for a formula to hide my previous days from the excel table I imported on 12th of Ferbruary. The reason is that I will use it to show the planned amounts of tests to be done in today and following days but we are not interested in what was in plan yesterday, but rather I did several cards and KPIs to show yesterdays values.

Although I did try to find an answer, most of the questions&answers are oriented on how to show the data from previous days and I need the opposite.

I would appreciate if someone could help me with this one. 

Thank you!

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Dynamic-value-in-datatime-QueryFilter/m-p/360343#M162637