Thank you very much! I've understood the problem with my approach. Best regards!
Here is a file, with problem. List.Max doesn't work properly, I can't see why.
Yes, of course. I added. In the query that it is called AtemptToAutomate everything works until I add word in front of the longest string of text. For...
Thank you for response. I added the file to explain what I mean. The main point is to split data by the longest string and with new added data in sou...
Of course I can't and I don't try, I mean I have this function and three rows = Table.SplitColumn(#"Table Name", "Column Name", Splitter.SplitTextByAn...
I also did it more dynamic if other users will search for solution it can be helpful for them: (Source as table, Column as text, Value as text, Col...
Thank you very much, it is what I meant.
Here is code (Source as table,Value as text)=> let #"Grouped Rows" = Table.Group(Source, {"City"}, {{"Total", each List.Sum([Sales]), type numbe...
Hi Philip, thx for reply, I mean I'm writing custom function and the part of it is selecting necessary rows - = Table.SelectRows(#"Changed Type", e...