Forum Discussion
Solved
Multiple Excel load, some data include subcategory values and some only total value
Hi! I have to import multiple excel files into Power BI to produce my Power BI reports. This part is easy. The problem I'm facing is that some data include subcategory values and some not. Any ...
Can you just combine the files and then filter the combined table to remove where the Subcategory is blank?
Pat
Can you just combine the files and then filter the combined table to remove where the Subcategory is blank?
Pat