Forum Discussion
Anonymous
6 years agoNot applicable
Filter out highest integer value in power query
How to Filter out highest integer value in power query. ( only in power query which will be compatible in excel too please) Below is the table I have, I need to filter out highest number which...
- Anonymous6 years ago
Thanks, I am kind of new to the power query.
Would you be able to edit below , something is not wokring when I changed. Emp.2 is the table that need to consider.
let Source = Csv.Document(File.Contents("C:\test.csv"),[Delimiter=",", Columns=17, Encoding=1252, QuoteStyle=QuoteStyle.Csv]), #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]), #"Removed Other Columns" = Table.SelectColumns(#"Promoted Headers",{"Emp"}), #"Split Column by Delimiter" = Table.SplitColumn(#"Removed Other Columns", "Emp", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, true), {"Emp.1", "Emp.2"}), #"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Emp.1", type text}, {"Emp.2", Int64.Type}}), #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Emp.1"}) in #"Removed Columns"
Greg_Deckler
6 years agoCommunity Champion
You want to get rid of the 16's, is that correct?