Forum Discussion
Helper IIIDealing with horizontal figures
When you import the data set, you have an option in the Query Editor called "Unpivot". This will let you convert the data into records that will better suit how you will create your reports.
When you import the data set, you have an option in the Query Editor called "Unpivot". This will let you convert the data into records that will better suit how you will create your reports.
Hello,
What would I have to do if I have to combine multiple files that are in this horizontal format (1 file for each year of data)? When combined and loaded into PowerBI, these two files are stacked on top of eachother. If I unpivot the dates based on the first file that appears on top, I am unable to unpivot the second set of dates from the 2nd file.
1st File:
2nd File:
- StidifordN
I think you need to post an example/sample of the different datasets to get a concise answer.
Can do! Thanks for the tip; I've edited my original post.
StidifordN wrote:I think you need to post an example/sample of the different datasets to get a concise answer.
