Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi!
I'm working on creating a dynamic title that shows all of my selected FieldParameters, in a neat way.
I've currently got it so that it shows all of the parameters I've selected, but they just come after eachother without spaces.
Is there any way to get it so I can display them with perhaps a space and a "&" between each one? Dynamically ofc...
Currenct code:
var _year1 = MIN('dim Calendar'[Year])
var _x = CONCATENATEX('FP BFo', 'FP BFo'[FP BFo])
return
_x & " per " & _year1
Current result: Parameter1Parameter2Parameter3 per 2022
Desired result: Parameter1 & Parameter2 & Parameter3 per 2022
Solved! Go to Solution.
You can pass an additional parameter to CONCATENATEX to act as the delimiter
Title =
VAR _year1 =
MIN ( 'dim Calendar'[Year] )
VAR _x =
CONCATENATEX ( 'FP BFo', 'FP BFo'[FP BFo], " & " )
RETURN
_x & " per " & _year1
You can pass an additional parameter to CONCATENATEX to act as the delimiter
Title =
VAR _year1 =
MIN ( 'dim Calendar'[Year] )
VAR _x =
CONCATENATEX ( 'FP BFo', 'FP BFo'[FP BFo], " & " )
RETURN
_x & " per " & _year1
Of course... thanks!