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?  
  • Ahmedx's avatar
    3 years ago

    Pls try this

     

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