Forum Discussion
Current Week or Week to date calculation
Hi,
I want a gauge visual which shows which week i am in currently out of the total number of week of my program. Any idea how to do that?
Any help would be appreciated!
Thanks!
Hi Anonymous ,
According to your description, I create a sample, here's my date table.
Table = CALENDAR(DATE(2021,9,1),DATE(2022,6,30))I create two measures by the DATEDIFF function.
Total Week No = DATEDIFF(MIN('Table'[Date]),MAX('Table'[Date]),WEEK)Passed Week No = DATEDIFF(MIN('Table'[Date]),TODAY(),WEEK)Then put Passed Week No in value and Total Week No in Max value, get the result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous , check if my blogs on WOW can help you
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.Hi Anonymous ,
According to your description, I create a sample, here's my date table.
Table = CALENDAR(DATE(2021,9,1),DATE(2022,6,30))I create two measures by the DATEDIFF function.
Total Week No = DATEDIFF(MIN('Table'[Date]),MAX('Table'[Date]),WEEK)Passed Week No = DATEDIFF(MIN('Table'[Date]),TODAY(),WEEK)Then put Passed Week No in value and Total Week No in Max value, get the result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
