Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create a String from colums

Hello,  I want to create a string like follows: "The opened calender weeks are CW21/CW20/CW19/CW18". I have a column with starting with the latest calender week, like this: CW21 CW20 CW19 CW18 ...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    I would be something like

    "The opened calender weeks are " &
    CONCATENATEX ( TOPN ( 4, VALUES ( TableName[Column1] ), DESC ), TableName[Column2], "/")