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)"}})),

 

I created the following Custom column:
Added_Custom = Table.AddColumn(#"Removed Columns", "Custom", each List.Count(List.Range(List.Select(Record.FieldValues(_), each _<>""), HeadersToShift)))

 

I expected to ge the following error:

Expression.Error: We cannot convert a value of type List to type Number.

 

How can I solve it?

 

Thanks

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 _ <> ""))

     

2 Replies

  • Akash_Varuna's avatar
    Akash_Varuna
    Super User
    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 _ <> ""))