Forum Discussion

SidsDataAnalyst's avatar
SidsDataAnalyst
Regular Visitor
5 years ago
Solved

how to create measure which will divide column from two different tables

I have one table(FactPrice) with the Product price list column, product name column, mobile no column, and another table(FactQuanity) with Product Quantity column, Mobile no column. i want to divide the price column from this Factprice table with the quantity column of the factQuantity table.

How to do it? 

Thanks in advance

Need Help
  • ponnusamy's avatar
    ponnusamy
    5 years ago

    SidsDataAnalyst :

    Try this if you are using  product id as row 

    Sample Data I used

     

    Table Relationship 

     

    (Ignore bi-directional relationship since its sample file) single direction is recommended 

2 Replies

  • ponnusamy's avatar
    ponnusamy
    Icon for Solution Supplier rankSolution Supplier
    5 years ago

    SidsDataAnalyst :

    Try this if you are using  product id as row 

    Sample Data I used

     

    Table Relationship 

     

    (Ignore bi-directional relationship since its sample file) single direction is recommended