Forum Discussion
Impactful IndividualWeek 52 exists in both December as January
I was looking at my data and had something odd. If I have it by year-weeknum combination, week 52 consisted of days 25-31, but also day 1 by ISO norm the week didn't have the first thursday within.
How... is this normally solved in order to have the weeks containing dates that are chronologically?
2 Replies
Hi DouweMeer ,
Please review the following links, hope they can help you get the expected result.
How to calculate ISO week number and ISO year in DAX - Data Cornering
database - Power BI: Week #'s not sorting properly - Stack Overflow
Best Regards
DouweMeerThe DAX solution seems to be a crude one:
But you can make it work. However, making 1 jan 2021 show up as week 53 year 2020 is not one of common sense and some sales people will trip over that seeing sales they know ended up in 2021 being in 2020.
