Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 lo...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

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

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

    Thanks very much appreciate it