Forum Discussion
Date Filters
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,
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
2 Replies
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