Hi,
I have successfuly made a COUNT based on Group By columns. See below for the snippet that works.
#"NoO_Removed Other Columns" = Table.SelectColumns(Source,{"Partition", "Invoice Date", "Branch Name"}),
#"NoO_Grouped Rows" = Table.Group(#"NoO_Removed Other Columns", {"Partition", "Invoice Date", "Branch Name"}, {{"Number of Orders", each List.NonNullCount([Partition]), type number}}),
What I would like to do now is COUNT a number of individual columns by the same Group By. I can do this separately and then merge the individual COUNTS together, however I would like to achieve the result using a single line of code. I am having trouble achieving this. Below is my snippet of code that is failing:
#"NoO_Removed Other Columns" = Table.SelectColumns(Source,{"Partition", "Invoice Date", "Branch Name", "Postcode", "DMS Place"}),
#"NoO_Grouped Rows" = Table.Group(#"NoO_Removed Other Columns", {"Partition", "Invoice Date", "Branch Name"}
{{"Number of Orders", each List.NonNullCount([Partition]), type number}},
{{"Count of Postcode", each List.NonNullCount([Postcode]), type number}},
{{"Count of DMS Place", each List.NonNullCount([DMS Place]), type number}}
),
The error I'm getting is:
-------------------------------------------------------------------------------
Expression.Error: We cannot apply indexing to the type List.
Details:
Value=List
Index=List
-------------------------------------------------------------------------------
Can it actually be done? If yes, then what do I need to change in my failing snippet of code?
Thanks in advance.
