Using Concatenate in DAX in PowerPivot as a Measure
Results 1 to 3 of 3

Thread: Using Concatenate in DAX in PowerPivot as a Measure

  1. #1
    New Member montyfern's Avatar
    Join Date
    Oct 2017
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Using Concatenate in DAX in PowerPivot as a Measure

    Good Day,

    Thank you in advance for answering this question. I can't combine two fields with an "x" value. For example, I'm combining lumber height & width so I write a calculated column =CONCATENATE(Data[Height],[Width]) and it shows 812 instead of 8x12. So then I read several websites & tried =CONCATENATEX(Data,[Height] & "x" & [Width]) and unfortunately it combines all of them for values fields, making very long strings "6x126X128X126X146X14" etc. In "regular Excel," I'd use =TEXT(B2,"00")&"x"&TEXT(C2,"00") but I can't figure out how to transform this into a cool DAX calculation. I'm only using measures in Power Pivot, or calculated columns, NOT Power BI. My goal is to write KPI's in Power Pivot.

    Thanks so much!

  2. #2
    Board Regular
    Join Date
    Nov 2016
    Posts
    99
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Using Concatenate in DAX in PowerPivot as a Measure

    CONCATENATE only works with two text strings. You need to nest a second CONCATENATE function in the expression =CONCATENATE(Data[Height],CONCATENATE(" x ",Data[Width])). Or just use the & operator =Data[Height] &" x" & Data[Width]). Don't use CONCATENATEX for this example.

  3. #3
    New Member montyfern's Avatar
    Join Date
    Oct 2017
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Using Concatenate in DAX in PowerPivot as a Measure

    Thanks very much! I knew it was fairly simple, & that it only accepted two text strings, but just couldn't get there. Thx. again!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •