Forum Discussion
Solved
Excel Data Transformation help
Hello guys, I have an excel export whihc has a format as shown and i'm quite new to Power BI to get result like shown. As shown in below screesnhot, from below main table column'ON' is datetime ...
Hi isaudag1 , I would suggest using the Power Query to process the data. Try using the following steps:
- Select the Range on the Worksheet
- Choose the "from table/range" button on the Data custom ui menu
- Select my table has header row
- When in Power Query, there is a Fill Down function to populate the "Group", "Description", "Area", "Priorty" columns (Table.FillDown)
- Filter the equipment column to remove the blanks (Table.SelectRows)
- Use the Group By (Table.Group) to group on the "Group" and "Equipment", count the rows.
- Re-order the columns.
Note that you create the visual using the results of Step 5.
Hi isaudag1 , I would suggest using the Power Query to process the data. Try using the following steps:
- Select the Range on the Worksheet
- Choose the "from table/range" button on the Data custom ui menu
- Select my table has header row
- When in Power Query, there is a Fill Down function to populate the "Group", "Description", "Area", "Priorty" columns (Table.FillDown)
- Filter the equipment column to remove the blanks (Table.SelectRows)
- Use the Group By (Table.Group) to group on the "Group" and "Equipment", count the rows.
- Re-order the columns.
Note that you create the visual using the results of Step 5.
Fill down option is very helpful. Thanks