Creating Calculated Column Based on Multiple Tables and Filtering

hello amanda_wahlig ,

yes, have a dimension table that have the distinct staff names and link it to all the tables with the records.

then you can see the data from all tables with this staff name from the dimension table.

Hello! Ideally you always want to model to a star schema (fact and dimensions). The employee table would be a dimension table in this case and the joins to the fact tables allow the fact tables to be used together in a visual through fields from the dimension. Here is a blog I wrote about star schema: http://powerbiwithme.com/2023/07/30/the-star-schema-edition/