Date Filters

[Anonymous]

Hi

Is there a way to add a date filter that looks at any data before todays date? So when the report is published and a user looks at it the date filter brings up any data before the date they look at it (if that makes sense).

thanks 

[Anonymous · Accepted solution]

@Anonymous,

There are tow methods for you to get the above result.

1. Create a calculated column using DAX below. Then create a slicer using this column and selecting 0 in the slicer to filter your  visuals.

checktoday = IF(Table[DateKey]=TODAY(),1,0)

2. Create a measure as below in your table, then drag the measure to a card visual. This measure display all data before today.

salesbeforetoday = CALCULATE(SUM(Table[SalesAmount]),FILTER(Table,Table[DateKey]<TODAY()))

Regards,
Lydia

[Anonymous]

Thanks very much appreciate it