Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

How to calculate value between two queries?

Hi Everyone,   It is hard for me to calculate like this.   Any help is appreciable. Thank you in advance!   Regards, Kelly
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    8 years ago

    Without calculation it won't be possble.

     

    Possibly you want to know how to do it in Power Query:

     

    let
    Source = Query2,
    #"Merged Queries" = Table.NestedJoin(Source,{"First Level Group", "Second Level Group"},Query1,{"First Level Group", "Second Level Group"},"Query1",JoinKind.LeftOuter),
    #"Added Custom" = Table.AddColumn(#"Merged Queries", "Custom value", each [Reference] * Table.RowCount([Query1]), Int64.Type),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Reference", "Query1"})
in
    #"Removed Columns"
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks a lot!

 

In addition, Could you tell me how to get the data without calcuation? Thanks in advance!

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
8 years ago

Without calculation it won't be possble.

 

Possibly you want to know how to do it in Power Query:

 

let
    Source = Query2,
    #"Merged Queries" = Table.NestedJoin(Source,{"First Level Group", "Second Level Group"},Query1,{"First Level Group", "Second Level Group"},"Query1",JoinKind.LeftOuter),
    #"Added Custom" = Table.AddColumn(#"Merged Queries", "Custom value", each [Reference] * Table.RowCount([Query1]), Int64.Type),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Reference", "Query1"})
in
    #"Removed Columns"