Forum Discussion
Need Help with Data Model and Fact Tables
Sorry, I had an issue with my posting above and didn't get exactly what I wanted.
My dimension table will be joined to the fact tables by the department and then date for my date table. Attached is my first draft at a model with only one cost drivers. From here I am not sure if I add extra fact tables for the other cost drivers or if I add the additional drivers and the account (driver name) to my current table called "tons". In this model, "job" is "department". Thanks.
Coming to Power BI from SQL can be confounding at times, but it looks like you're doing fine. It would probably be better to add the gl account number and put all your driver information in one fact table. That way you model is 2 "stars", 2 fact tables that share 2 dimensions.
The relationship lines in Power BI really are about how the filters move when you place them, so with a star you can filter the dimensions and the relationship moves across to the fact table. Keeps it simple
Another big difference from SQL is that almost all Power BI models make use of a "Calendar table", a helper table that greatly increases your ability to filter. You can find lots of examples and free code for builgin them on the internet. The calendar would be another dimension and probably be related to both your fact tables.