Forum Discussion
Replace text
click on edit query, and then select advanced editor, copy and paste text from advanced editor and I will add the step for you.
goto edity query->advanced editor and add following line before "in" and make sure to add comma (",") on existing last step of the query
#"Replaced Value" = Table.ReplaceValue(#"<your last query step here>",each [Col A], each [Col C],Replacer.ReplaceValue,{"Col A"})
Assuing this is the last step in your query, replace last line in query query after "in" with this
#"Replaced Value"
Could you send me pictures please?
click on edit query, and then select advanced editor, copy and paste text from advanced editor and I will add the step for you.
i have come across the same issue can u help me out
for this i am not geeting wat is the error
let
Source = Access.Database(File.Contents("C:\DAT207x\PowerBI.accdb")),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each [Date] > #date(1999, 12, 31))
in
#"Filtered Rows"
