Forum Discussion
Impactful IndividualPower bi calculated tables
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
If your tables are calculated, presumably you have the measures/calculated column formulas already. Can't you just add one to the other?
4 Replies
- Idrissshatila
Super User
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 👍
- BIswajit_Das
Thanks for responding but
Merging not going to work on calculated tables
SanderVeekenHelper III
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
