Current Week or Week to date calculation

[Anonymous]

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!

[v-yanjiang-msft · Accepted solution]

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 _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@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=pnAesWxYgJ8

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

I am talking about a gauge like this. I have the total no. of weeks but i am not sure how to add the current weeks passed in the program (the green progress bar). I want something which calculates the no. of week passed from current date and the start date of my program.