Forum Discussion

Strongbuck's avatar
Strongbuck
Helper I
3 years ago

Compiling data from various criteria (two columns)

The data I am importing has two columns that determines what company the item is related to.  I am trying to create a Power BI graphic that reports the count of data about how long the companies are ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Strongbuck ,

 

You can use Merge to join tabls. I'll take Company Table as an example, and so on for the rest of the table.

1.Create a custom column with "Company" in Company Table.

 

2.Use Merge Queries. Pay attention to the numbers of the matching columns, which should correspond one to one.

3.Expand it to see the corresponding columns.

Merge queries overview - Power Query | Microsoft Learn

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

  • Strongbuck's avatar
    Strongbuck
    Helper I
    3 years ago

    Hi Stephen,

     

    I see what you did.  Can you please confirm that this would work for the role data.  For that one, you need to lookup the users associated to the role and then get the company key to join that to the company table.

     

    I'm asking this because the role data is a one to many relationship.