I want to setup a report that will present data to the end user using the “best available” data that we have. I plan to maintain 3 databases with identical structure in each of them. There will be “Prelim Data”, “Final Data Unverified” and then “Final Data Locked “.

I want to be able to report on best available data. So if there is “Final Data Locked” in a cell, use that, otherwise use “Final Data Unverified”, otherwise “Prelim Data”

Firstly, I am able to create a new table and manually add columns with the below code, but is there an easier way to create the whole table without me writing code for every column? (There will have over 100 columns)

A = if(isblank(lookupvalue('Final Data Locked'[A],'Final Data Locked'[Test Data],'Data To Use Table'[Test Data])),if(isblank(lookupvalue('Final Data Unverified'[A],'Final Data Unverified'[Test Data],'Data To Use Table'[Test Data])),lookupvalue('Prelim Data'[A],'Prelim Data'[Test Data],'Data To Use Table'[Test Data]),lookupvalue('Final Data Unverified'[A],'Final Data Unverified'[Test Data],'Data To Use Table'[Test Data])),lookupvalue('Final Data Locked'[A],'Final Data Locked'[Test Data],'Data To Use Table'[Test Data]))

Secondly, and this is probably a nice to have only, it would be amazing if the user could toggle the report to exclude “Prelim Data” and/or “Final Data Unverified” so they only see the report with “Final Data Locked.” Is there an easy way to achieve this?
I have done in the past through a selected value being used on measures, but since it is currently either through calculated columns or possibly calculate table, unsure if there is achievable?

Data Example