Forum Discussion
Solved
Employee data modelling
Hi, I am new to power BI and need some assistance in modelling the employee of a small firm for the power bi application. I have employee data for 3 months with the following feilds and need to crea...
Hi,
You should place all Excel files (one for each month and with the same structure month on month) in a single folder. Using Query Editor of PowerBI desktop, append data from all Excel files. Create a Calendar Table and build a relatioship from the Date column of your appended dataset to the Date column of the Calendar Table.
We can then write measures to model your data and build visuals.
Thank you Ashish for the guidance.
You are welcome.