Forum Discussion

dofrancis3's avatar
dofrancis3
Icon for Resolver I rankResolver I
1 year ago
Solved

Concatenate colomns

Dear Colleaues,

Hope your doing well !
Please could you help me with DAX mesure that can allow me to concatenate colomns.

Please ci-example below :

Thank you for your support

  • There's no magic to it.  Remember that measures work on tables, not on rows.  To concatenate columns use a calculated column:

     

    conc = [City] & ", " & [Region] & ", " & [Number] & " - " & [Hour]

2 Replies

  • There's no magic to it.  Remember that measures work on tables, not on rows.  To concatenate columns use a calculated column:

     

    conc = [City] & ", " & [Region] & ", " & [Number] & " - " & [Hour]