Combine Week No: and Week name/ID

[AllanBerces]

Hi Good day,

Can someone pls need assistance on my query, I have table with Week No. and I want to add column with Week name on its week no. something like below.

Thank you

[Bibiano_Geraldo · Accepted solution]

Hi @AllanBerces ,

Create a new column on your table with the following DAX:

Week ID = "Week: " & Table[Week No.]

Make sure to replace the table and column names with your owns 

[AllanBerces]

Hi @Bibiano_Geraldo thank you very much, all good.

[Bibiano_Geraldo]

You're welcome @AllanBerces