Hi,
I'm running a power query on a table of data. However, when I apply a sort, Power Query returns a table of Nulls. Any ideas why, please, and how to fix this?
My code is:
Thanks.
I'm running a power query on a table of data. However, when I apply a sort, Power Query returns a table of Nulls. Any ideas why, please, and how to fix this?
My code is:
Code:
let
Source = Excel.CurrentWorkbook(){[Name="Opp_SF_Export"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Opportunity ID", type text}, {"Close Date", type datetime}, {"Account ID", type text}, {"Owner ID", type text}, {"Created Date", type datetime}, {"Name", type text}, {"Opportunity Type", type text}, {"Probability (%)", Int64.Type}, {"IsCreatedFromLead", type logical}}),
#"Sorted Rows" = Table.Sort(#"Changed Type",{{"Created Date", Order.Ascending}, {"IsCreatedFromLead", Order.Descending}, {"Probability (%)", Order.Descending}})
in
#"Sorted Rows"
Thanks.