Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to 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 _ <> ""))
Thanks a lot.
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 _ <> ""))