Relative date filter to generate End of Day Report the day before.

[skis]

Hi,

I've been using relative date filter (in this day or in this last 1 days )on my report page for just sending out the End of day report everyday and it's been working fine completely.  Now, I want to send the End of day report of the day before on the current day. For example, today is 11/13/2020. Instead of sending 11/13/2020 report tonight, I need to send 11/12/2020 EOD report. Can this be done using relative date filter or should I use another approach ? 

Thanks in advance. 

[skis · Accepted solution]

Found a solution.

Create a calculated column, let's call it as Date Conversion= DATEDIFF(MAX('Table'[DateColumn]),('Table'[DateColumn], DAY). Then, include this column name in filters on this page and choose -1 in the basic filtering. What it does is, in the 'Table'[DateColumn], it picks the day before your current date and displays the visuals associated with that date.