Forum Discussion

EaglesTony's avatar
EaglesTony
Post Prodigy
2 years ago
Solved

How do I add a filter to a Table.AggregateTableColumn

hi,     I have the following, which is working as expected: = Table.AggregateTableColumn(#"Merged Queries1", "Expanded AgileTeams", {{"Parent", List.Count, "Count of Expanded AgileTeams.Parent"}})...
Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    2 years ago
    Done Employee Count =
    var curParent = [Parent]

    var final =

    COUNTROWS(FILTER('Check Table', [Parent] = curParent && 'Check Table'[Status] = "Done" && [Parent] <> BLANK()))
     
    Return 
    If(Final = BLANK(), 0, Final)
EaglesTony's avatar
EaglesTony
Post Prodigy
2 years ago

It is just renaming a column.

SamWiseOwl's avatar
SamWiseOwl
Super User
2 years ago

Hi @EaglesTony 

This step

#"Renamed Columns3" = Table.RenameColumns(#"Aggregated Expanded AgileTeams",{{"Count of Expanded AgileTeams.Parent", "SolutionEpicChildCount"}})

 

Refers to the old table:

#"Renamed Columns3" = Table.RenameColumns(#"Aggregated Filtered Rows",{{"Count of Expanded AgileTeams.Parent", "SolutionEpicChildCount"}})