Forum Discussion
Count Serial if Outgoing Reps Time is between Sign In Start and Finish Time
Hi Gao,
Thank you for response.
I have both tables linked to dimnsion table Officer because officer name is different in Sign In and Outgoing Reps and also link to other Calendar Dimension Table for Date.
I have copied the Formula and changed the Table Name but I am getting the following message.
This formula is invalid or incomplete: 'The column 'Sign In[Start]' either doesn't exist or doesn't have a relationship to any table available in the current context.'.
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 ExcelBest Regards,
Gao
Community Support TeamIf 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