Create person tracker from target per month

[dickyalsyah]

Hi, everyone

I have difficult chase, here is my sample dataset and the result tracker at the end of the sheet that I want to make power bi dashboard.

https://docs.google.com/spreadsheets/d/1CPHWAgpoEeKYGXb8Ca7FEnXSZWcaQLzY7xIj-ysngxs/edit?usp=sharing

Could anyone provide me, how to do that and explain to me the table hierarchy and the relationship.

Highly appreciated your help. 

[amitchandak · Accepted solution]

@dickyalsyah , I made an attempt. The answer is not the same as yours. Maybe I am using the wrong date.

Please find the attached file after signature

[dickyalsyah]

Hi, thank you it's work. But, could you drive me again sir.

I want to filter the employee which is the employee is active based on join date and resign date. So the example result is when the slicer goes to Dec 2021, the table shows only with the employee active, but I can still see the progress of the employee history before he resigned. 

[v-janeyg-msft]

Hi, @dickyalsyah 

You haven't responded to me. Let me explain again, I asked you the expected result because I don’t know how your target month is got and what does 'the progress of the employee history before he resigned' mean? 

Your needs are not difficult, it just depends on how you want to display.

If you still need help, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[v-janeyg-msft]

Hi, @dickyalsyah 

Can you share your desired result for reference?