Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
14 | |
8 |
User | Count |
---|---|
75 | |
50 | |
47 | |
16 | |
13 |