Forum Discussion
Find missing data
Hello, I need a way to compare data in two different data sources to see if an event is missing. For instance, if a child is enrolled in the program, I need to know if they are missing a screeni...
Hi, Anonymous ;
You could try to create a new table by dax.
Table = ADDCOLUMNS( EXCEPT(VALUES(TableA[ChildPlus Name]),VALUES(TableB[ChildPlus Name])), "site",CALCULATE(MAX('TableA'[Program name]),FILTER('TableA',[ChildPlus Name]=EARLIER(TableA[ChildPlus Name]))))the final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I added the tables and some more details about what it is I need. Do you have any other advice?
my advice is you share a sample of your Model and give more details on how you want to see the outcome.