Forum Discussion
Column with Tables, m code function problem
Hello. I have a problem. I want to extract information from the table into one cell. And I have errors like in this picture. The aim is to create a dynamic function to use in the column function Cou...
I found solution:
(mytable as table)=> let Source = Excel.Workbook(mytable, null, true), #"Demoted Headers" = Table.DemoteHeaders(mytable), #"Changed Type" = Table.TransformColumnTypes(#"Demoted Headers",{{"Column1", type text}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each #"Changed Type"{0}[Column1]), #"Filtered Rows" = Table.SelectRows(#"Added Custom", each Text.Contains([Column1], "2a Wentylacja mechaniczna - 5 pkt. Wszystkie ")), #"Counted Rows" = Table.RowCount(#"Filtered Rows") in #"Counted Rows"
Hi Anonymous - It is not clear what you are trying to achive from the information provided. I am not sure you have a valid function. I would not expect this line to work
#"Demoted Headers" = Table.DemoteHeaders(#"Transform File (6)")
because you have selected a String or Number in the previous step instead of a table.
Can you step out an example in Excel or upload an example PBIX file.