Forum Discussion
Subscription with pre-set date to show
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.
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.
1 Reply
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.