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.
aj1973
Community Champion
Community ChampionHi Anonymous
It is always helpful to share a sample of your model in order to have an acurate reply to your thread.
All said I think you can add a column in each of the source to indicate 0 if the child is there and 1 for true. and then compare the substraction avec the sum of the 2 columns.
I added the tables and some more details about what it is I need. Do you have any other advice?
- aj1973
my advice is you share a sample of your Model and give more details on how you want to see the outcome.