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.
Hi Guys.
I've got an excel file that I am trying to pull into Power BI. The file has a number of "Merged" columns in Excel:
I would like a single column for dates, a single column for either "staff" or "wages" through Power Query Editor. Or is there an easier way to do this?
Solved! Go to Solution.
don't forget to change the excel file address
Can you please share your demo input and expected output!
the best way to do this is in Power Query Editor
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |