Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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