Forum Discussion

wneiton's avatar
wneiton
Resolver I
7 years ago
Solved

concatenate calculated column

Hi   I'd like some help!   I need to concatenate NF + MI + MV and put the result in Criterios Column.  NF,MI,MV are calculated columns.    That's my table.    My goal is to get a conca...
  • ajohn1's avatar
    7 years ago

    I got this example from here: https://msdn.microsoft.com/en-us/query-bi/dax/concatenate-function-dax

     

    Criterios = Concatenate(NF, Concatenate(",", Concatenate(MI, Concatenate(",", MV))))

     

    [Edited, I didnt see you already had commas. I also did this with calculated columns from my data. You might need to update your desktop version if this is not working for you.] 

     

    Criterios = Concatenate(NF, Concatenate(MI, MV))

  • wneiton's avatar
    wneiton
    7 years ago

    Hi ajohn1

     

    It worked, I used this expression: 

    Criterios = CONCATENATE(FIXED(SomaTotal[NF];2);CONCATENATE(FIXED(SomaTotal[MI];2);FIXED(SomaTotal[MV];2)))

    however, I don't know why, but I got the dot as a result instead of comma. Look at the picture below. 

     

     

     thanks!