Power bi model relationship

[James13]

Hi guys need help, how can i dynamically display a persons supervisor from the previous week in power bi, given that the supervisor changes weekly, using date slicer. Also i have a lot of tables used for his/her matrics. 

[v-cgao-msft · Accepted solution]

Hi @James13 ,

Not sure what model you are using. I made a simple example that will project last week's personnel supervisor based on the maximum date of the slicer.

Please refer to the attached pbix file.

You can also refer to the link below to provide more non-private data and expected outputs.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[IoannisPhilip]

Hi @James13 ,

You will need
1. to create a Calendar Table --> examples here
2. use Time intelligence functions for the metrics you mentioned that include the above table --> link here
3. create dimension tables: dimSupervisors and dimEmployees --> link here

Given that you have all the above you should be able to create what you are looking for. If you could provide screenshots or examples, maybe I can support further. Let me know how it goes.

Best,
Ioannis