Multiple Excel load, some data include subcategory values and some only total value

[dhannaa]

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 Ideas how this is best tackled?

1) Subcategory data is provided, good. No need for total rows
2) Here total rows are the only source for data so they are needed after all
3) File might include both mentioned so the decision should be made on a monthly basis after all

[mahoneypat · Accepted solution]

Can you just combine the files and then filter the combined table to remove where the Subcategory is blank?

Pat