Reply
TechR21
Helper V
Helper V
Partially syndicated - Outbound

Weeknumber is wrong

Hi,

 

I have the following table":

date1.png

Now iI created a column to have the weeknumbers

date3.png

 

but when i look, the numbers are matching but the numbers of the week are off. as you can see these two records are created in week 45, and not 46.

 

What am i missing here?

 

date2.png

 

1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
Community Champion

Syndicated - Outbound

WEEKNUM has an optional return type which establishes when the week begins (day of week and week of year):

WEEKNUM ( <Date> [, <ReturnType>] )

weeknum.jpg

 

 

See here for further detail:

https://dax.guide/weeknum/ 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

2 REPLIES 2
djurecicK2
Super User
Super User

Syndicated - Outbound

Hi @TechR21 ,

 This article might be helpful to you. Weeknum accepts a parameter than can change the output.

 

https://learn.microsoft.com/en-us/dax/weeknum-function-dax

Please consider accepting as solution if this has answered the question.

PaulDBrown
Community Champion
Community Champion

Syndicated - Outbound

WEEKNUM has an optional return type which establishes when the week begins (day of week and week of year):

WEEKNUM ( <Date> [, <ReturnType>] )

weeknum.jpg

 

 

See here for further detail:

https://dax.guide/weeknum/ 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)