Forum Discussion

MAG_PRG's avatar
MAG_PRG
Regular Visitor
3 years ago
Solved

Weeknum function error - can't get ISO week

From all the documentation I have seen, this DAX code should give me the ISO week number for today:

Week = WEEKNUM(Today(), 21)

But this is giving me an error, saying 21 is not the correct parameter type. When it gives me the available options, only 1 and 2 appear:


The documentation here seems to clearly state that 21 is a valid option for return_type:
https://learn.microsoft.com/en-us/dax/weeknum-function-dax

Does anyone know why it will not accept 21 as the parameter?

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  MAG_PRG ,

     

    According to research, a similar issue has been reported internally.

    I will update here once I get any information.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • jk13's avatar
    jk13
    Frequent Visitor

    I have the same issue with my existing WEEKNUM function!

    WEEKNUM(TODAY(),2) is giving me since yesterday also the "Parameter is not the correct type" error breaking many reports..
  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi  MAG_PRG ,

     

    According to research, a similar issue has been reported internally.

    I will update here once I get any information.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.