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.
Hello Community,
My calendar starts from 01/01/2021 to 01/12/2022. I am using WEEKNUM to find the week number in the table.
I am getting the right week num for 2021, but when 2022 starts, I want to start with weeks from 54,55,56,57, not from 1,2,3,4, etc.
Can anyone suggest me some logic?
Solved! Go to Solution.
@tejapowerbi123 Use Sequential: https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231#M116
Thank you so much Greg.
@tejapowerbi123 Use Sequential: https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231#M116
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |