Forum Discussion
Solved
Flat Excel File to Data Model Help
Relatively new to PowerBI and want to pick the brain of some experts. How would you go about cleaning up an excel file that looks like the below (With the query editor or Excel) for a solid data mode...
Ignore the Total Market columns, you get those for free.
Have a Calendar table, a dimension table for your data subject hierarchy, and a fact table for the numbers.
Ignore the Total Market columns, you get those for free.
Have a Calendar table, a dimension table for your data subject hierarchy, and a fact table for the numbers.