Filter by today's date

[Anonymous]

Hi, I have a table with sales data for last year and this year. I have visuals that show these data, and I also want to add a visual with today's sales figures.

What is the best way to only filter records with Today's date?

Thanks

[v-caliao-msft · Accepted solution]

Hi @Anonymous,

Add a column in your date table by using the DAX expression below.
Today = IF(Table1[Date]=TODAY(),1,0)

Then in your visual which you only show today's sales, add a filter like below:

Regards,

Charlie Liao

[Anonymous]

Worked. Thank you.