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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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