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
Need Help
  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    1 year ago

    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 

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Super User
1 year ago

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