Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
We are in week 40, in either system 1 and 2. But pbix returns 41, why??
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)
Hi @ovonel
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!!
Hi @ovonel
https://docs.microsoft.com/en-us/dax/weeknum-function-dax#remarks
Try this:
User | Count |
---|---|
57 | |
21 | |
19 | |
17 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |