Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Transform date to weeknumer in year gives the wrong result

I have a date - and by right-clicking on the header -> Transform -> Week -> Week of year, I get the weeknumber.

 

However, the weeknumber provided does not fit with the calendar - as we should be in week 1now.

 

Power BI starts with week one 1. January which is a Friday and not a Sunday, which I read is the start day in Power BI (though I think it should be Monday).

 

Anyone having the same isue/know whar to to?

 

Transform date to weeknumber.PNG

Status: New
Comments
Anders_No
Regular Visitor

Hi @v-lili6-msft ,

 

I was not aware that weeknumbers had different definitions until I saw mikejarods post - so yes, that was my issue.

 

Thank you so much for your time - I will try a work around!

 

Regards

 

Anders