How to Calculate the Total Earning Of Active & Inactive Staff

[ADSL]

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? 

[ADSL · Accepted solution]

Hi @punitkhatri & @v-yiruan-msft ,

It's resolved after go through this posted and helpful feedback from team.

Posted: https://community.powerbi.com/t5/Desktop/How-to-calculate-and-find-the-Inactive-amp-Active-Employees... 

Thanks and Regards,

[punitkhatri]

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

[v-yiruan-msft]

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]

Hi @v-yiruan-msft ,

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,