COUNTIFS($A$1:A1,A1) Formula in Power Query? Excel Magic Trick 1588
Download Excel File: https://excelisfun.net/files/EMT1588....
Learn how to create a Power Query Custom Column Formula that has an expandable range, counts based on the row condition and is equivalent to the Excel Worksheet Formula COUNTIFS($A$1:A1,A1). See how to use the Power Query Functions Table.AddColumn and Table.SelectRows. Also see how to create Two Custom Functions so we can access the Outside Table and Inside Table in the same formula.