Forum Discussion
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. ...
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.