Forum Discussion

Piet's avatar
Piet
Frequent Visitor
8 years ago
Solved

Multiple two different columns from two different tables

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    s...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    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

  • Piet's avatar
    Piet
    8 years ago

    it works.

    thanks a lot

    Piet

alexei7's avatar
alexei7
Icon for Continued Contributor rankContinued Contributor
8 years ago

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