I have two dataset. The first one contains some data like:
The second one contains the SerialNumber and the DataManufatured
As you can see on my example, I have much more items on Table2 then I have on Table1, and I would like to know how can I calculate the average number of days since manufactured for those items listed on Table1 only.
Something like this:
So, in this case if the item is not on Table1, it should not be considered, no matter whether I have something selected or not.