Forum Discussion
Count Serial if Outgoing Reps Time is between Sign In Start and Finish Time
Is there anyway I can fix this? I am just playing around but not finding a correct solution 🙂
I don't see Sign In table in the dropdown but I have this table linked to dimension table.
Thank you
Hi mouzzampk ,
Are you using excel? Please try to refer to the steps in this document to create a relationship.
Create a relationship between tables in Excel
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
Hi Gao
Thank you for helping me out with this. I have attached the spreadsheet. As you can see I have Officer fields from both Sign In and Outgoing Reps linked to Dimesion Table (Officer)
I hope the attached spreadsheet will give more details.
Thank you
mouzzampk