Forum Discussion

cole_lehmkuhler's avatar
cole_lehmkuhler
Icon for Helper II rankHelper II
10 years ago
Solved

Using information from another table

Okay I have 4 tables. A "sales query" table which has 40k rows and is sales information about sales for a quarter and there are columns for 'account #' and 'control #', but no column for customer gro...
Need Help
  • Nhallquist's avatar
    Nhallquist
    10 years ago

    I think you can do this.  I would left-join the Control# Total Sales numbers to the Control numbers in the Customer Group table.  This should be a 1-to-1 relationship based on Control number.  Then, you can Sum the Control number sales by Group in the Power BI app.

     

    I think that will work, based on what I read above.  If this won't work, let me know and we'll keep working on it.

     

    Nate

Nhallquist's avatar
Nhallquist
Icon for Helper V rankHelper V
10 years ago

I think you can do this.  I would left-join the Control# Total Sales numbers to the Control numbers in the Customer Group table.  This should be a 1-to-1 relationship based on Control number.  Then, you can Sum the Control number sales by Group in the Power BI app.

 

I think that will work, based on what I read above.  If this won't work, let me know and we'll keep working on it.

 

Nate

  • cole_lehmkuhler's avatar
    cole_lehmkuhler
    Icon for Helper II rankHelper II
    10 years ago

    Right again! Thanks for the help!