Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I would like to get concatenated year week in table visual in Power BI. Having column Week number. I got this result:
Seems year week is unsorted. I used this formula to for column Year week.
Solved! Go to Solution.
Hi @Analitika,
You can add a calculated column to extract the year and week number value from the date to concatenate and convert to numeric, then these values can be sorted by ASC/DESC order on your visuals.
YearWeek =
YEAR ( 'Table'[Date] ) * 100
+ WEEKNUM ( 'Table'[Date], 2 )
Regards,
Xiaoxin Sheng
Hello,
I would like to ask how I can sort ascending column which is constructed from year and week. I am getting year week column but sorting is not as in normal case. For example,
Hi @Analitika,
You can add a calculated column to extract the year and week number value from the date to concatenate and convert to numeric, then these values can be sorted by ASC/DESC order on your visuals.
YearWeek =
YEAR ( 'Table'[Date] ) * 100
+ WEEKNUM ( 'Table'[Date], 2 )
Regards,
Xiaoxin Sheng
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
3 | |
2 | |
2 | |
2 |