Make one table using different raw data tables

[catsy]

Hello,

Good day. Appreciate anyone's help on this concern:

I have 2 tables as example below:

Table A

DATE	QUANTITY
Jan 1, 2020	10
Jan 1, 2021	20

Table B

DATE	QUANTITY
Jan 1, 2020	20
Jan 1, 2021	30

I would like the above to show in powerbi as one table:

	Jan 1, 2020	Jan 1, 2021
Table A	10	20
Table B	20	30

Is that possible? Note that tables a and b has no column named as "Table A" or "Table B"

Thanks in advance!

[v-henryk-mstf · Accepted solution]

Hi @catsy ,

According to your needs, you can use "append" in power query to merge into a new table, and then create a new column through dax with the content "TableA" and "TableB". Finally, put the corresponding field in the matrix to get the result.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@catsy , Add a column in Dax of power with the table name and use that.

You need to add the column of the table name is both dates. Then create a table having table names. Also need to create a date table. Join to both these tables with the Date and table name table and analyze the data across

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/