wrong week returned?

[Anonymous]

We are in week 40, in either system 1 and 2. But pbix returns 41, why??

[Anonymous]

15 means, week begins on friday? (that is not what I want... week begins on monday).

As I have it my dimDate:

Date, Week

2020-12-31 53
2021-01-01 53
2021-01-02 53
2021-01-03 53
2021-01-04 1

****

2021-12-31 52
2022-01-01 52
2022-01-02 52
2022-01-03 1

(which return_type shall I use to match the above)

[VahidDM]

Hi @Anonymous 

Use 21 as a return_type in your DAX.

Output:

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

Appreciate your Kudos!!

[VahidDM]

Hi @Anonymous 

https://docs.microsoft.com/en-us/dax/weeknum-function-dax#remarks

Try this:

Measure = WEEKNUM(TODAY(),15)

Output: