Power bi calculated tables

[BIswajit_Das]

There's two tables
i.e
table1

ac	price
1	34
1	34
2	23
3	21
4	45
5	32

and
table2

ac	year
1	18
1	18
2	12
3	23
4	20
5	21

result table should be like

ac	price	year
1	34	18
2	23	12
3	21	23
4	45	20
5	32	21

Thanks

[SanderVeeken · Accepted solution]

If your tables are calculated, presumably you have the measures/calculated column formulas already. Can't you just add one to the other?

[BIswajit_Das]

Incase of calculated columns it's required relationship between these two tables which is not possible in my case but measure do work perfectly.
Thank you

[Idrissshatila]

Hello @BIswajit_Das ,

You can do a merge between these two tables to reach the result of the third one which is a combination of both.

check this for instructions https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[BIswajit_Das]

Thanks for responding but

Merging not going to work on calculated tables