I have some data that has come in a messy format (see attached).
I need to clean it into a format, that will make it accessible for Power BI.
I need to unpivot the date and values, so there would be a column for date, hours worked, cost.
I have some data that has come in a messy format (see attached).
I need to clean it into a format, that will make it accessible for Power BI.
I need to unpivot the date and values, so there would be a column for date, hours worked, cost.
Last edited by samparker095; 05-27-2022 at 09:06 AM. Reason: Clicked enter to quick
I used this macro on a part of your data.
Please Login or Register to view this content.
See the attached file, with the result on sheet output.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Here is a solution using Power Query which you can implement through Power BI
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks