Forum Discussion

tgordon's avatar
tgordon
New Member
6 years ago
Solved

Transpose data from calculated columns

I have a set of data organized as shown below:   Project Quarter for Revenue Y1 Revenue Y2 Revenue 2020 Q1 2020 Q2 2020 Q3 2020 Q4 2021 Q1 2021 Q2 2021 Q3 2021 Q4 Project A 2020 Q...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi tgordon 

    you could create a custom column in Power Query. it could be the same as your calculated column (but it depends on your data model). after that - pivot/unpivot functions in power query

    do not hesitate to give a kudo to useful posts and mark solutions as solution

az38's avatar
az38
Community Champion
6 years ago

Hi tgordon 

you could create a custom column in Power Query. it could be the same as your calculated column (but it depends on your data model). after that - pivot/unpivot functions in power query

do not hesitate to give a kudo to useful posts and mark solutions as solution