Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX Weeknum

Hi   Here in year 2021 I notice several of my reports where I use a "Year Week" DAX function, the result gives the wrong week number. Data from 4th of  january to 10th should show up as in week 1,...
Need Help
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

    Hi Anonymous ,

     

     

     

    Regards,

     

     

Payeras_BI's avatar
Payeras_BI
Solution Sage
5 years ago

Hi Anonymous ,

 

I am glad it helped.

 

In additon to get the first three days of 2021 in your Year Week calculated column like 2020-53 and not 2021-53 use the following code for the ISO Year:

 

 

Regards,