Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Mic1979
Post Partisan
Post Partisan

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

1 ACCEPTED SOLUTION
Akash_Varuna
Community Champion
Community Champion

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

 

View solution in original post

2 REPLIES 2
Mic1979
Post Partisan
Post Partisan

Thanks a lot.

Akash_Varuna
Community Champion
Community Champion

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

 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.