Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Filter by today's date

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 r...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    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

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    Worked. Thank you.