I’m going to make a couple guesses, since I can’t see the rest of your tables.
- This is medical info (unable to be shared)
- There’s a lookup table that matches up Patient info somewhere off-screen
- There isn’t a stand-alone date table
Your ask is to add dates to the other 2 fact tables from DSS data.
With a date table in place, you can create relationships to your fact tables, and perform any of the time intelligence reporting that you can think of, without having to create calculated columns to chew through every time you load/refresh your report.
Here’s Sam’s blog on date tables:
I hope this helps.