Forum Discussion

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

Calculate Employee Resigned by month

Dear BI Community Team,

 

I have a table of employee as below that have joining date & resigned date. And we want to know:

> How many of employee Resigned

> How many of employee Active

That's number count will be showing when we choose the month

Any suggestion and advise? Link - https://drive.google.com/drive/folders/1qHhehLPKVympUE3KgHkXBm0f-m5rzYrn?usp=sharing 

 

Thanks and Regards,