Forum Discussion

amanda_wahlig's avatar
amanda_wahlig
Frequent Visitor
2 years ago
Solved

Creating Calculated Column Based on Multiple Tables and Filtering

I have multiple tables tracking the work of our staff (completely different types of work items means we can't use the same table to track it all) - each work item is assigned to a staffer, so obviou...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    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.

  • audreygerred's avatar
    audreygerred
    2 years ago

    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/ 

amanda_wahlig's avatar
amanda_wahlig
Frequent Visitor
2 years ago

I was mostly looking for tips on how to create the dimension table. I wound up referencing the needed columns and appending them into a new table, then removing duplicates. That way we don't have to manually change the reference table.