Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
i think it is a simple question :
Hwo can i multiple two different columns (cost * sales_quanity) from two different tables:
table1
item cost
4711 99,90
table2
item sales_quantity
4711 300,00
Cost-gross= ???????
Best regards
PIET
Solved! Go to Solution.
Hi @Piet,
That's should be easy if you could create a relationship between the two tables.
Have you solved the problem with the answers from @quentin_vigne and @alexei7?
If you have solved, only thing that you'll have to notice, just 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.
If you still need help, please feel free to ask.
Best Regards,
Cherry
it works.
thanks a lot
Piet
Hi @Piet,
That's should be easy if you could create a relationship between the two tables.
Have you solved the problem with the answers from @quentin_vigne and @alexei7?
If you have solved, only thing that you'll have to notice, just 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.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi @Piet
If there is a joint between your 2 tables the formula will be :
Cost-gross = table1[cost] * table2[sales_quantity]
- Quentin
Hi Piet,
Yes this should be quite simple. If in the relationships view of Power BI desktop you check that table1 is joined to table2.
Then you can create your formula ("cost * sales_quantity").
When you create your table make sure you bring in the "item" field from table1.
Thanks
Alex