Forum Discussion

ADSL's avatar
ADSL
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

How to Calculate the Total Earning Of Active & Inactive Staff

Hi BI Community Team,

 

I have 02 tables -- monthly earning by employee & employee master that have join & resign date.

 

Within these tables, we want to know and get some information below:

 

1. Total Earning by employee & month

 

2. Join & Resign employee must show when choose the month ---> currently, it's not working when choose the month that have some employee resigned.

 

Any suggestion? 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi ADSL ,

    As checked your description and attached pbix file, I'm not clear about your requirement. Could you please provide your expected result with the specific examples base on the sample data in the attached pbix file? For example, currently, you choose all years and January, what's your expected result? Is [Total Expense] 810.29 correct? And for employee 100001 and 100002, they resigned on January, 2023. Whether they should be included in the visual?

    Best Regards

    • ADSL's avatar
      ADSL
      Icon for Post Prodigy rankPost Prodigy
      3 years ago

      Hi Anonymous ,

       

      Thank you for your feedback and feel sorry of question.

       

      I want to know the Inactive employee when month selected. For screenshot, In Jan'23 there are 02 inactive employee. 

       

       

      But when month selected on Feb'23, it's still showing 02 inactive employee. It should be zero (0).

       

      So any suggestion/advise? If want to see Inactive employee based on month selected.

       

      Thanks and Regards,

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I think you have not selected status (Inactive) in the filter section, try doing that.