Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

Combine Week No: and Week name/ID

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

  • 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