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

parry2k's avatar
parry2k
Super User
6 years ago

tgordon it will be easy to provide a solution if you share how does your raw data looks like and there is potential solution looking at it.