Forum Discussion
Help with Data modelling two fact tables
Hi All,
I would really love help understanding multple fact tables,
I have two tables to compare ERP system times and also payroll times,
In the left hand table I have the Employee Number from the DayforceEmployee Table and the date from the Date table.
The other dates in the next two tables are from their respective tables.
Could you assist why the date isn't showing up in the left hand table with data from both tables?
There is no date in the Employee table to link to the DateTable.
Thank you for looking!
create a visaul table with 3 date columns from 3 tables and see if they have the same values, if not that is your problem: Power BI cannot match your date formats. Then go to Power Query and try to convert them to the same date or numerical (YYYYMMDD) format. if you are new to Power BI, feeding example might help you to get a conversion formula to unified date format: Add a column from an example (Power Query) - Microsoft Support
4 Replies
are you sure that your date relationships actually work? try to use date from dim table for visaul tables 2 and 3 to check that.
No I'm not sure that's why I'm asking for help, The Dayforce table only works with the date from the Dayforce Table, and the Dealer Pro Table only works wiht the Date from the Dealer Pro table.
I've connected the Date table to these so I'm not sure why the date table isn't working.
create a visaul table with 3 date columns from 3 tables and see if they have the same values, if not that is your problem: Power BI cannot match your date formats. Then go to Power Query and try to convert them to the same date or numerical (YYYYMMDD) format. if you are new to Power BI, feeding example might help you to get a conversion formula to unified date format: Add a column from an example (Power Query) - Microsoft Support
well I feel like an idiot. After all my transformations, I didn't transform the two date columns into date format -_-.. Thank you so much for your assistance!