Forum Discussion
Data relationship modelling issue
Hi all, I have a date query which is listed on the top, and i have two fact tables on salaries. The first one indicates shift hours per employees, and the one on the bottom indicates total salary ...
Dont just import data as it is storted on source systems.
Model the data so you can report it easily.
Use Power Query to model your data into start schema like this ...
Learn about star schema modelling here