Forum Discussion

robertocarlos's avatar
robertocarlos
New Member
9 years ago
Solved

dynamic rolling date (last 7 days)

I am simply trying to put a dynamic date filter to show me a filtered result of this table of the last 7 days (Test Date) everytime this report is opened.                          ...
  • th3h0bb5's avatar
    th3h0bb5
    9 years ago

    Hey Robertocarlos,

     

    My apologies, I had the less than symbol backwards. It should be <=7 instead of >=7.

     

    Use that calculated column and place it as a page-level filter with it's value set to 'Yes'. This should filter out everything except rows where the Date Column is in the last 7 days.

TristanKuesters's avatar
TristanKuesters
Resolver I
9 years ago

I also looking for a solution to find a rolling date for my report for the last month.

 

I want to share my solution. It is a calculated column on the date table.

 

IsLastMonth = IF('Calendar'[Month]=MONTH(today())-1 && 'Calendar'[Year]=YEAR(TODAY());"Yes";"No")

 

And a page/report filter to YES for this column.