Forum Discussion

Mic1979's avatar
Mic1979
Post Partisan
1 year ago
Solved

Dynamic List of counts function

Hello all,   I would need to count the non blank columns in the following range:  HeadersToShift = List.Difference (Headers,List.Combine ({BOM_Headers, {"Part Number (BOM)"},{"Description (BOM)"}}...
Need Help
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi Mic1979 I think what the issue is that List.Count is being used with an incompatible input, as HeadersToShift isn't applied correctly. For this, could you try:

    List.Count(List.Select(List.Transform(HeadersToShift, (header) => Record.Field(_, header)), each _ <> null and _ <> ""))

     

Mic1979's avatar
Mic1979
Post Partisan
1 year ago

Thanks a lot.