Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have massaged some data from an excel documents with some merged columns and simplified it to the screenshot below.
The second and third columns (HRS and Postpaid) are related by date, so are the 4th and 5th columns, and so on.....
What I am trying to accomplish is to promote HRS and Postpaid to the header and move the date (which is the header for HRS) into its own column.
I want to do this for every single date in the data. Currently, there is only one instance of each store with dates going horizontally. The end result should show me one HRS and one Postpaid column with dates going vertically and as many instances of a store as there are dates.
Hopefully that made sense. I think that the ask is simple enough but I may not have explained it well. Let me know. THanks in advance!
You said you have simplified it. I don't see that 😞
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |