Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.