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.
Created a Dates table that includes a column for Week Number using DAX WEEKNUM function. Most of the data is correct, however for some reason every 10th week is showing up as 6-digit numbers that increment for each day of that week. This is the case for week numbers 10, 20, 30, 40 and 50. In example below, 143527 is Sunday, 143528 is Monday, etc. of week number 10. I tried changing data format for Week column from Text to Whole Number and even deleted and re-created the table, but still having the issue. Does anyone know how to fix this?
Solved! Go to Solution.
@kjssdca ,
Do not use format in that column. You only need Weeknum([Date],1)
@kjssdca ,
Do not use format in that column. You only need Weeknum([Date],1)
@kjssdca , Please mark the solution
Hi @kjssdca ,
Try this code:
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 |
---|---|
44 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |