Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
3 years ago
Solved

Pivot Columns

Hello,  Please see the Current data set up and future .  How can I achieve this?  I have tried all pivot columns options but none are providing this result.  Any thoughts?

 

Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    Pls try this

     

    =  
VAR _t = MAX('table'[ID])
RETURN
CONCATENATEX(FIILTER(ALL('table'),'table'[ID]=_t),[CURRENT WFM],";")

     

3 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    Pls try this

     

    =  
VAR _t = MAX('table'[ID])
RETURN
CONCATENATEX(FIILTER(ALL('table'),'table'[ID]=_t),[CURRENT WFM],";")

     

    • mlsx4's avatar
      mlsx4
      Memorable Member
      3 years ago

      Just a little correction on your formula. Filter has two "I", jcastr02 wants a ";" as delimitator and adding a space will result in a more legible way:

       

       

      Measure=

VAR _t = MAX('MyTable'[ID])
RETURN
CONCATENATEX(FILTER(ALL('MyTable'),'MyTable'[ID]=_t),[WFM],"; ")

       

       

      But Ahmedx formula is perfect