Bomino
Member
Hi,
I am learning M Language and I really need help: I have the following 2 Power BI queries and I was wondering if it is possible to combine them into one.
Query#1:
And query#2:
Any help is greatly appreciate. Thanks.
I am learning M Language and I really need help: I have the following 2 Power BI queries and I was wondering if it is possible to combine them into one.
Query#1:
Code:
let
Source = myfile,
#"Grouped Rows" = Table.Group(Source, {"Column1", "Column2", "Column3", "Column4"}, {{"Count",each List.Count(List.Distinct([Column5])),Int64.Type}})
in
#"Grouped Rows"
And query#2:
Code:
let
Source = myfile,
#"Grouped Rows" = Table.Group(Source, {"Column1", "Column2", "Column3", "Column4"}, {{"TotalSum", each List.Sum([Column6]), type number}})
in
#"Grouped Rows"
Any help is greatly appreciate. Thanks.