Forum Discussion

Uspace87's avatar
Uspace87
Icon for Resolver III rankResolver III
2 years ago

Data modelling

Hi all,   I n my model I got a "Date Table", "Product Table", a fact table with "Sold qty" by date and by product and then I got anothe table with all the "Product Unit cost" by product, by date. ...
Need Help
Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
2 years ago

Hello Uspace87 ,

 

in the data modeling you will be having the date and product tables linked to both facts, and calculate a dax measure to see sold qty from fact table * the unit sold from the second fact table.

 

you then display the measure  with respect to the product from the product table.