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 ...
  • ponnusamy's avatar
    4 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