Dynamic List of counts function

[Mic1979]

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

[Mic1979]

Thanks a lot.

[Akash_Varuna · Accepted solution]

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