Week of year issue

[Anonymous]

Hi Team,

Am using direct query mode because the dataset is huge and all transformations are done in databricks. there is one data timestamp column from that am extracting week of year in databricks and loading data to powerbi.

Till 2020 the week number is coming correctly but when it comes to dec 2021 52nd week the graph is showing incorrectly.I have attached images below for reference.

image2

In the above image in starting graph it is showing dec52nd 2021 week and in below image also it is showing dec 52 week 2021 means it showing 2times and for feb 9th week 2022 and march 9th week 2022 is also showing 2 times.

The data should not show duplicate weeks. Can someone please help with above issue.

Thanks in advance

[amitchandak]

@Anonymous , Based on what I got you should create a sort column on year week

like

[year]*100 + [week] and mark that as sort column for week

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)
Week Number = WEEKNUM([Date],2)

[Anonymous]

Hi @amitchandak ,

Am using direct query mode so i cant add above queries.