Forum Discussion

selected_'s avatar
selected_
Helper IV
4 years ago

How to put columns in same query via get data SQL statement?

I'm trying to do custom column calcuation via the get data when choosing snowflake.  from the window box i fill server name, WH and databse details and then in the SQL statment window I write my cus...
Need Help
Show and Tell
shugh's avatar
shugh
Frequent Visitor
4 years ago

Hi there, 

 

By just doing the query:

select sum(column) from adventureDW

 

You are just querying the database but if you wanted to combine data with other sources you would need some kind of join column so your query would look something like this:

 

select joincolumn, sum(column) from adventureDW

 

Then in PowerQuery you can then join this table to another table to bring the data together by using the merge feature and selecting the matching column between the two tables to merge on.

 

Apologies if this isn't on the right lines, you may need to provide screenshots for further info.

  • selected_'s avatar
    selected_
    Helper IV
    4 years ago

    Hi,

    No it's not join. 

     

    You can move for example measures into another tab but is that possible to do it for columns?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi selected_,

      How about creating a static table in your database with the calculated fields to get the total result from the particular table? I think it should fix the temp result table issues.
      In addition, you can also consider invoking the stored procedure which returns the summarized values.

      Regards,
      Xiaoxin Sheng