Forum Discussion

Nun's avatar
Nun
Resolver I
3 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
    3 years ago

    Hi Nun ,

     

    You could use CONCATENATEX() function.

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

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Nun ,

 

You could use CONCATENATEX() function.

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

 

Best Regards,

Jay

Nun's avatar
Nun
Resolver I
3 years ago

Thanks Jay, I solved the issue creating a measure with

CONCATENATEX. A measure which contains a double concatenatex (one for the city and one for the month) & 
YEAR(TODAY()) (to get the year)...in this way I can get the correct city and correct month when the user uses the filters City and Month.
 
Br.