@Thimios ,
Great – glad to hear that worked well for you.
With regard to the data model, here are the issues that I see:
-
generally, to simplify your DAX significantly and sometimes to increase performance as well, you will want to avoid the snowflake schema in favor of the classic star schema. This is particularly true here, where the dimension tables that you’ve snowflaked off of the Supplier Pricelists table are are all single column tables, so they are not gaining you anything. They should all be deleted.
-
I believe the Newly Bought Items table can be deleted from the model and the logic within can be recreated inside a measure if needed
-
the Supplier Pricelists is a classic slowly changing dimension table. You are going to need to figure out how you want to manage changing prices over time. There are a number of different accepted strategies for doing so. I think in this case my preference would be to have a start and end date associated with each price (with the end date being blank for the current price) then in the appropriate measures you could build in the logic for selecting the correct price given the relevant date value within the fact table.
Here are some other relevant forum threads that lay out alternative approaches and the pros and cons of each.
I hope this is helpful to you.
– Brian