Forum Discussion
Help comparing dates between tables
Hi there, I am hoping someone can help me with this. Have spent hours and hours looking through the solutions posted and cant figure out. I have two different systems for people to enter timeshee...
rdops - If you have the names of the person in a visual then you could do something like:
VAR __Name = MAX('Table'[Name])
CONCATENATEX(
EXCEPT(
SELECTCOLUMNS(FILTER('Table1',[Name]=__Name),"Date",[Date]))
SELECTCOLUMNS(FILTER('Table2',[Name]=__Name),"Date",[Date]))
),
[Date],
","
)
So, basically, get me all the dates from table 1 and take away all of the dates from table 2 so now the ones left are the missing ones.
Thanks Greg.
I tried but couldnt make it work. I guess I am just to jr for the tool.
Thanks anyway