Forum Discussion

SID010517's avatar
SID010517
New Member
3 years ago

Power BI

Hi,

 

I just started to use Power BI but it seems a little complicate without knowledge.

I need to compile 4 data files :

1) Each day work by employee

2) Employee list with personal information

3) day which employee worked on a worksite 

4) day which employee has an absence or presence 

 

I need to compile all these data to know who worked when and where or which absence or presence.

 

Could somebody help me ? May be possible to share my screen and data

Rgds

SID010517

 

Need Help

2 Replies

  • AbbasG's avatar
    AbbasG
    Memorable Member
    3 years ago

    SID010517 if you can share sample data (after removing all the sensitive information) with the desired output, it will be easy to answer your query.

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    Hi SID010517 

     

    You may need to learn about relationships in Power BI first. Please read this blog (Creating And Managing Relationships In Power BI) to learn about what relationship is and how to create/manage relationships in Power BI. 

     

    Relationship in Power BI is used to define the connections or the relation between two or more tables. The relationship is used when we want to perform an analysis based on multiple tables. Relationship helps us to display the data and correct information between multiple tables. It is used to calculate the accurate results also.

     

    The second table "Employee list" usually can be a Dimension table. I think there must be some common column in all tables, e.g. Employee ID or Employee Name. Create relationships from "Employee list" to the other three tables. Then you can try to add a table visual to the report. Add "Employee list" table's "Employee ID" column to the table, then drag data columns from other tables into the same table visual. Check the result you get. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.