Forum Discussion
Last full month from last refresh
Hi,
I have a report that needs to be updated every month.
The refresh only update the dataset and not the date slicer in the report. Dashboards based on those date slicers will not be updated as well. I was think making a date slicer based on the Lastrefresh date and I would like to have the last full month of the lastrefresh date.
I tried:
dateadd(lastrefresh[lastrefresh];-1:month
I did not get a value/date back.
How to solve this problem or is there another way to make sure the slicers are updated with refresh and hereby the dashboard?
Hi Anonymous ,
You can't do this directly in the report designer, but you should be able to do some modelling to make it work.You may refer to the post below.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
V-lianl-msftCommunity Support
Hi Anonymous ,
You can't do this directly in the report designer, but you should be able to do some modelling to make it work.You may refer to the post below.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.