The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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
Solved! Go to Solution.
Can you just combine the files and then filter the combined table to remove where the Subcategory is blank?
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Can you just combine the files and then filter the combined table to remove where the Subcategory is blank?
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.