You can't really replicate joins with a calculated field.
If you add filters to your report / extract it will impact how the SQL is generated though.
Thanks Tom. I assume custom SQ is the way to go as I have multiple tables. I cannot ask back end team to create a single view. I can blend on date.