Help comparing two excel worksheets in Power BI

[shirya]

Hi. I need help - i have data in say 5 worksheets in excel. each sheet has data for a particular day . The headers and rows are same. values in cells for each day differ . I want to create a report combining data from these worksheets , How do i do that.

Say I need to combine production values for Machine No 1 from these 5 worksheets and show .Thanks

[v-jiascu-msft · Accepted solution]

Hi @shirya,

You can import the 5 queries and append them together as a new query. 

Best Regards,

Dale

[shirya]

Hey

Thanks Dale

Got what I wanted ,,

Though I must say I find "Tableau" software more user friendly . But I guess PowerBI will take time getting used to,