Subscription to dashboard, but updating week number

[ssze]

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!

[v-zhangti]

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.

[v-zhangti]

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.