Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hi all,
i'm trying to set up a subscription for others with a dashboard so people have up-to-date customer orders vs supplies.
The dashboard is set up with a slicer with year and week number.
Subscription works perfectly for what the week has been set up for, but is there a functionality to make the subscription go to the latest week number every monday?
Thank you in advance!
Hi, @ssze
Maybe you can refer to the following link hope it will help you.
https://www.youtube.com/watch?v=lWx4VoCM55E
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @ssze
This calculation assumes weeks begin on Monday.
WEEKNUM = WEEKNUM([Date],2)
You can use this function to add a new column for the time on the dashboard. For more details, please refer to the following documentation. https://docs.microsoft.com/en-us/dax/weeknum-function-dax
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.