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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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