Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi guys, not sure if this is possible:
In Table 1 I have a column called Amount Table1[Amount]
In table 2 I have a clumn called Extra Table2[Extra]
What I want to do is on Table 1 sum those two values in a new column:
New Column = Table1[amount]+ Table2[Extra]
Solved! Go to Solution.
Hello ,
first to make this work you should make a relationship between the tables and you should have a unique identifier , you have 3 options :
1- merge the 2 tables in power queries
2- make a new table in power bi as a summarize
3 - measure in a column in table 1 : Total = Table1[Amount] + RELATED(Table2[Extra])
measure 3 will work if you have realationship correct .
Kindly accept as a solution if it works with you and a kudo would be greatfull .
Regards ,
Hello,
I have the same problem but in my case i would to do division "/" calcul. I have two tables that i create relations (Months-Months) and i would like to create a new column that i do this calculation : column A from table A / column B from table B.
Thank you very much in advance
Dear ,
Check if you have a unique table , you can use related or lookupvalue with the devide measure .
Thanks ,
Dear ,
Can you share some data to help you with solving it .
Regards ,
Hello ,
first to make this work you should make a relationship between the tables and you should have a unique identifier , you have 3 options :
1- merge the 2 tables in power queries
2- make a new table in power bi as a summarize
3 - measure in a column in table 1 : Total = Table1[Amount] + RELATED(Table2[Extra])
measure 3 will work if you have realationship correct .
Kindly accept as a solution if it works with you and a kudo would be greatfull .
Regards ,
Thanks work fine. The problem was the relationship between the tables.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
89 | |
87 | |
77 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |