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.

th3h0bb5's avatar
th3h0bb5
Resolver II
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.

elatreille's avatar
elatreille
Helper I
9 years ago

Are you using a measure or a column?

I am trying to display the last 2 days data so data from yesterday and the day before. I am using a measure as is:

last_2_days = IF(DATEDIFF('Date'[Date],TODAY(),DAY)<=2, "Yes", "No") but having an issue with this field 'Date'[Date].

It returns a single value for column date in table 'Date' cannot be determined...

So if I understand the formula you posted here it looks between 2 dates and if the difference is lower than 2 it will return YES and under the filter you add it there and if the value is Yes than the data will show.

 

So I have a date table with a relationship to my impression table to the date field. I want to display the total impressions from 2 days before today... (yesterday and the day before)

 

How do I do that?