topic Re: Concatenate colomns in DAX Commands and Tips

Concatenate colomns

dofrancis3 — Mon, 14 Oct 2024 20:02:08 GMT

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

lbendlin — Mon, 14 Oct 2024 21:12:43 GMT

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]

dofrancis3 — Mon, 14 Oct 2024 22:49:21 GMT

Thank you lbendlin