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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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