Forum Discussion
Trouble with blanks
This relates to tracking timecard submittal status. Users submit their timecard to a share point list. We need a PowerBI visual to show users that have and have not submitted their timecard to the sharepoint list.
I have 2 table sources. One is a list of of active employees. The second source that looks at Sharepoint to see is a timecard has been submitted.
I want to show all active employees and a yes / no if they have submitted there time card. The issue is that in Sharepoint, if a user has not submitted, there is no entry in the list. I am join the two via EMPID field which exists in both tables. Currently set as a 1 to many relation ship with active employee table be the the on
1 Reply
Hi chadd391 ,
Please try this measure.
Measure = IF(SELECTEDVALUE('Active Employees'[EMPID]) IN DISTINCT('Timecard'[EMPID]),"Yes","No")Best 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
