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.
Hi all,
In the monthly reports the subscriptors receive the report in the 2nd week of the next month.
In these reports, i would like to show the data updated till the last day of the previous month. For example the report this week sent: with data from 01-01-2020 till 30-04-2020. But the actual sent report showed data till 31-03-2020.
What can i do to change that?
There is a weekly refresh of the data, so that's not the problem. It's just that the ' till date' is not correct shown.
Solved! Go to Solution.
Subscription do not have similar features to filter the reports. For you requirements, you could just add a slicer on the reports to filter the date.
The slicer column can be:
previous month = IF(MONTH([Date])<MONTH(TODAY()),MONTH(TODAY())-1)
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Subscription do not have similar features to filter the reports. For you requirements, you could just add a slicer on the reports to filter the date.
The slicer column can be:
previous month = IF(MONTH([Date])<MONTH(TODAY()),MONTH(TODAY())-1)
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.