topic Year week in Power BI in Developer

Year week in Power BI

Analitika — Tue, 24 May 2022 07:52:30 GMT

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.

Year_week = FORMAT('Date'[Date],"YYYY") & "-" &'Date'[Week Number]

Week Number = WEEKNUM('Date'[Date],1).

How to resolve this issue by making ascending order year_week?

Sort column ascending year week

Analitika — Tue, 24 May 2022 09:59:02 GMT

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,

Year_week = FORMAT('Date'[Date],"YYYY") & "-" &'Date'[Week Number]

Week Number = WEEKNUM('Date'[Date],1)

Formulaes.

Re: Sort column ascending year week

Anonymous — Fri, 27 May 2022 01:08:37 GMT

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