Forum Discussion
Calculate Formula across Multiple Tables
I am new to Power BI and need some help.
I have 4 tables and I need to do a bar chart showing how many records in each table. Notes: The same ID can exist in multiple tables.
tblChair
tblComponents
tblCosmetics
tblHardware
Bar Chart example:
Hi,
Do all tables have the same structure? If yes, then why cane we not append data from all tables into one table and then create our desired visual. If they do not have the same structure, then which is the common column in all 4 datasets?
3 Replies
Hi,
Do all tables have the same structure? If yes, then why cane we not append data from all tables into one table and then create our desired visual. If they do not have the same structure, then which is the common column in all 4 datasets?
You are welcome.