Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
skis
Frequent Visitor

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

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. 

1 ACCEPTED SOLUTION
skis
Frequent Visitor

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.

View solution in original post

1 REPLY 1
skis
Frequent Visitor

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.