- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Weeknumber is wrong
Hi,
I have the following table":
Now iI created a column to have the weeknumbers
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
WEEKNUM has an optional return type which establishes when the week begins (day of week and week of year):
WEEKNUM ( <Date> [, <ReturnType>] )
See here for further detail:
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
WEEKNUM has an optional return type which establishes when the week begins (day of week and week of year):
WEEKNUM ( <Date> [, <ReturnType>] )
See here for further detail:
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.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
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.
Subject | Author | Posted | |
---|---|---|---|
03-17-2020 02:09 AM | |||
12-11-2024 04:50 AM | |||
12-22-2023 08:55 AM | |||
12-03-2024 03:57 PM | |||
09-29-2024 02:28 AM |
User | Count |
---|---|
101 | |
66 | |
48 | |
39 | |
32 |
User | Count |
---|---|
166 | |
112 | |
60 | |
56 | |
37 |