Using SELECTEDVALUE with Calculated Table workaround?

Hello,

I have a report that currently shows how many items were added to a database during a scan and the difference compared to the previous run. Clicking on any date in the graph changes the total findings to that date, and updates the change. If no date is selected, it defaults to the latest:

It works great, but what I would also like to do is create two other table visualizations that actually show the items that were ADDED and REMOVED between the selected scan and the previous scan, so we can see what items actually changed instead of just a count. I created this query that works ONLY for the most recent scan and the previous one to show items that were added; i.e., the data in the visualization never changes when selecting a new date:

Added = 
var __selectedDate =
    SELECTEDVALUE(
        calculated_filtered[scanned],
        MAX(calculated_filtered[scanned])
    )

var __previousDate =
    CALCULATE (
        MAX(calculated_filtered[scanned]),
        calculated_filtered[scanned] < __selectedDate
    )

var __newerTable =
    CALCULATETABLE(
        calculated_filtered,
        calculated_filtered[scanned] = __selectedDate
    )

var __olderTable =
    CALCULATETABLE(
        calculated_filtered,
        calculated_filtered[scanned] = __previousDate
    )

return

EXCEPT(
    SELECTCOLUMNS(
        __newerTable,
            "provider",[provider],
            "recommendation",[recommendation],
            "resourcegroup",[resourcegroup],
            "resourceid",[resourceid],
            "resourcename",[resourcename],
            "subscription",[subscription],
            "taskid",[taskid]
       ),
    SELECTCOLUMNS(
        __olderTable,
            "provider",[provider],
            "recommendation",[recommendation],
            "resourcegroup",[resourcegroup],
            "resourceid",[resourceid],
            "resourcename",[resourcename],
            "subscription",[subscription],
            "taskid",[taskid]
    )
)

I know this may not work since I'm using a Calculated Table and it may only run once, but even after selecting a date and hitting 'Refresh' it doesn't update the list so I'm not sure if I'm just doing something wrong or if there's a workaround to making something like this work. Any thoughts or help is appreciated!