Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

one parameter that swaps values for two different datasets.

Hi, hope someone can help with this because I'm very stuck. I have two different tables that pull from two entirely different datasets. For various reasons I can't combine the two datasets into on...
Need Help
  • Data-estDog's avatar
    Data-estDog
    2 years ago

    This is achievable. You need to build 3 common dimensions: LeadSource, Manager, and Department.

    Common Dimension = Dimension used by multiple data sets, typically fact tables. 
    Follow this video: Fact & Dimension tables in Power BI | Data Modelling - YouTube

     

    After you get your 3 dimensions and link them, it looks like you know the rest with the field params. 

    Don't forget to mark as solution and give a thumbs up if you found this helpful!

Data-estDog's avatar
Data-estDog
Resolver II
2 years ago

This is achievable. You need to build 3 common dimensions: LeadSource, Manager, and Department.

Common Dimension = Dimension used by multiple data sets, typically fact tables. 
Follow this video: Fact & Dimension tables in Power BI | Data Modelling - YouTube

 

After you get your 3 dimensions and link them, it looks like you know the rest with the field params. 

Don't forget to mark as solution and give a thumbs up if you found this helpful!