Forum Discussion
Create person tracker from target per month
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.
Anonymous , 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
4 Replies
- amitchandak
Super User
Anonymous , 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
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
Community Support
Hi, Anonymous
Can you share your desired result for reference?
