Subscription with pre-set date to show

[powerbivts]

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. 

[V-pazhen-msft · Accepted solution]

@powerbivts 

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.