I have a power query table that shows all my assets due throughout the year. At some point the PQ stopped working, even when I manually input dates into the fields. The Refresh button macro still works but I'm not sure if its updating. If assets due in 4th Qtr are updated to somewhere in the 2nd, the asset remains where its at instead of deleting from 4th and appearing in the 2nd. Each Quarter is its own PQ, if I'm not mistaken, but I'm not sure how to fix as someone else built the query. Below is the function used in the query with this formula in each "Steps applied": Source, Change Type, Removed Columns, Filtered Rows, Sorted Rows:
let
Source = Excel.CurrentWorkbook(){[Name="Pod_DB"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"POD", Int64.Type}, {"Location", type text}, {"PMI Due", type datetime}, {"Stat", type text}, {"TCN", type text}, {"Column1", type text}, {"Pod Notes", type text}, {"Location Notes", type text}, {"Settings", type text}, {"SSPA", type text}, {"CND Counter", type any}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Stat", "TCN", "Column1", "Pod Notes", "Location Notes", "Settings", "SSPA", "CND Counter"}),
#"Filtered Rows" = Table.SelectRows(#"Removed Columns", each Date.QuarterOfYear([PMI Due]) = 1),
#"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"PMI Due", Order.Ascending}})
in
#"Sorted Rows"
Thank you and please let me know if you need more info!
let
Source = Excel.CurrentWorkbook(){[Name="Pod_DB"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"POD", Int64.Type}, {"Location", type text}, {"PMI Due", type datetime}, {"Stat", type text}, {"TCN", type text}, {"Column1", type text}, {"Pod Notes", type text}, {"Location Notes", type text}, {"Settings", type text}, {"SSPA", type text}, {"CND Counter", type any}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Stat", "TCN", "Column1", "Pod Notes", "Location Notes", "Settings", "SSPA", "CND Counter"}),
#"Filtered Rows" = Table.SelectRows(#"Removed Columns", each Date.QuarterOfYear([PMI Due]) = 1),
#"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"PMI Due", Order.Ascending}})
in
#"Sorted Rows"
Thank you and please let me know if you need more info!