Hello good day!
they gave me an excel file where it contains a table with data ordered as follows which I do not understand how to sort them to handle them from powerbi since it has combined headers (escapes my knowledge).
the table contains its column "SUB CENTER OF COST BARRACKS" and "Labor" that would be related to another table of Area that I keep created, my problem begins with the following columns that detail the count of people by "week" and then is detailed in day as seen in the image. I must also say that the count that carries the table by date (week and detail in day) I want to relate it to a calendar table to have it related to my model.
What are the steps I should follow to be able to handle this data in the best way and relate it to my model?
Thank you very much for your help and time!
Helpful resources
Power BI Monthly Update - April 2026
Check out the April 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 34 | |
| 26 | |
| 25 | |
| 22 | |
| 18 |
