Power Platform Community Forum Thread Details

Hi all,

I hope I'm in the right place! I've adopted a query from a colleague and am attempting to alter it to suit my purpose. Want I want is for the query to pull individual's who's Tx Date is 28 days ago or more but I keep on getting the titled error?

let
Source = Access.Database(File.Contents("\\brhpvezb1002\CADAT_DB_BACKEND\CADAT Waiting List_be.accdb"), [CreateNavigationProperties=true]),
#"_Waiting list" = Source{[Schema="",Item="Waiting list"]}[Data],
#"Filtered Rows" = Table.SelectRows(#"Removed Columns", each [Referral Status] = "In Treatment" or [Referral Status] = "Awaiting Treatment"),
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each [Tx Date] < Date.AddDays[Tx Date]+28),
#"Filtered Rows2" = Table.SelectRows(#"Filtered Rows1", each [Qualtrics Tx pack sent] <> true),
#"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows2",{{"Tx Date", type date}}),
#"Removed Columns1" = Table.RemoveColumns(#"Changed Type",{"Disorder Specific Measure"})
in
#"Removed Columns1"

Any help would be greatly appreciated!!

Best,

Elizabeth

Categories:

Power Query