Forum Discussion
List Names that are NOT found on Dynamic Table
1. create a list of all users: var a= VALUES(Team[Name])
2. select all users that have punched today var b= calculate(values(Timecard[Name]),Timecard[Date]=TODAY())
3. Use EXCEPT to find the fallout var c = EXCEPT(a,b)
This is now a single row table with all users that haven't punched yet. Decide what to do with this table - use CONCATENATEX() to return it as a string, or use it as a filter elsewhere.
Super User1. create a list of all users: var a= VALUES(Team[Name])
2. select all users that have punched today var b= calculate(values(Timecard[Name]),Timecard[Date]=TODAY())
3. Use EXCEPT to find the fallout var c = EXCEPT(a,b)
This is now a single row table with all users that haven't punched yet. Decide what to do with this table - use CONCATENATEX() to return it as a string, or use it as a filter elsewhere.
This worked great. Took me a couple tries to get it completely right, as it was a bit unclear where these would be placed. Created tables with single columns, with the 'not completed' being the thrid and final, producing the list as needed.
Thank you!