Forum Discussion

Nun's avatar
Nun
Icon for Resolver I rankResolver I
4 years ago
Solved

Dynamic text with the switch formula

Hello, I have a table  Month   City  Jan         "Paris" Feb         "Madrid" Mar        "Berlin" Apr        "Zurich" Now I created a dynamic text with switch formula: SWITCH(TRUE(), VALUES(...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Nun ,

     

    You could use CONCATENATEX() function.

    Measure = CONCATENATEX('Slicer','Slicer'[Column1],"-")

     

    Best Regards,

    Jay

Shreeram04's avatar
Shreeram04
Icon for Resolver III rankResolver III
4 years ago

Hi Nun 

 

Try a Quick Measure called "Concatenated list of values".

 

Thanks

  • Nun's avatar
    Nun
    Icon for Resolver I rankResolver I
    4 years ago

    Hi Shreeram04 , thanks for your quick reply. I tested it, unfortunately the concatenated list of values doesn't  fully satisfy my need.

    Thank you!