New table with data from 2 other tables

[Lolokebek]

Hi,

I have Table A and Table B, which both have a column with dates. I also have a column with amounts from two categories of expenses.

I would like to make a chart to compare by month the amount for each category.

What I have actually:

TableA : Column Date, and Column CategoryA ($ Data)

TableB : Column Date, and Column CategoryB ($ Data)

What I would like to get:

Table C: Colum Date from table A and Table B, Column CategoryA and column CategoryB.

Is it possible to do that in Power Bi?

Thank you for your help.

Laurent.

[MFelix · Accepted solution]

Hi @Lolokebek,

The best way is to create a dimension calendar table abd relate this.with the other two tables then use it to make the.comparision between values.


No need to make a new table that merge both tables.

Regards,
MFelix

[Lolokebek]

Hi MFelix,

It worked.

Thank you very much. 🙂

Laurent.

[v-piga-msft]

Hi @Lolokebek,

It's glad that you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best Regards,

Cherry