Forum Discussion

TimQ's avatar
TimQ
Icon for Helper I rankHelper I
6 years ago
Solved

Use DAX to transpose column values based on relative date

I need to transpose or unpivot text values into separate columns based on relative date. My data looks like this: Unique ID Date Comment 1 7/1/2019 aaaaa 1 8/1/2019 bbbbb 1 9/...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi TimQ 

     

    Did you try Matrix?

TimQ's avatar
TimQ
Icon for Helper I rankHelper I
6 years ago

Thanks. This solution seems like it would work but due to a weird network circumstance I am unable to transform my data table in the query editor, so my solution would have to be executed as a series of DAX calculated columns in a visual.

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi TimQ 

 

Did you try Matrix?