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
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.
Solved! Go to 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.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
82 | |
76 | |
64 |
User | Count |
---|---|
143 | |
111 | |
108 | |
99 | |
95 |