Forum Discussion
Anonymous
4 years agoNot applicable
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
CW17
CW16
CW15
...
I always need the first 4 lines (here: 21,20,19,18).
How can i get a string just like shown above?
Thanks!
Hi Anonymous
I would be something like"The opened calender weeks are " &
CONCATENATEX ( TOPN ( 4, VALUES ( TableName[Column1] ), DESC ), TableName[Column2], "/")
1 Reply
- tamerj1Community Champion
Hi Anonymous
I would be something like"The opened calender weeks are " &
CONCATENATEX ( TOPN ( 4, VALUES ( TableName[Column1] ), DESC ), TableName[Column2], "/")