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],";")

     

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