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.
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 had to make a couple of tweaks to make it work but THANK YOU!!! I got it!!
Missing Screenings = ADDCOLUMNS( EXCEPT (VALUES('All enrollment 22-23'[Name (Last, First)]),VALUES('R8 screenings'[Name (Last, First)])),"SITE NAME",CALCULATE(MAX('All enrollment 22-23'[Site Name]),FILTER('All enrollment 22-23',[Name (Last, First)]=EARLIER('All enrollment 22-23'[Name (Last, First)]))))