Forum Discussion

skumar365's avatar
skumar365
Regular Visitor
8 years ago
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...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    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.

skumar365's avatar
skumar365
Regular Visitor
8 years ago

 

Thanks Gerg. Sorry unable to attach the actual file as there is no option to upload the file, but i have posted the picture of the tables below.

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

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.

  • skumar365's avatar
    skumar365
    Regular Visitor
    8 years ago

    Thank you Ashish for the guidance.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      You are welcome.