Forum Discussion
jracer007
8 years agoHelper IV
Replace text
Hello community, How can I replace the texts in column A with the texts in column C in Power Desktop?
- 8 years ago
click on edit query, and then select advanced editor, copy and paste text from advanced editor and I will add the step for you.
jracer007
8 years agoHelper IV
Could you send me pictures please?
parry2k
8 years agoSuper User
click on edit query, and then select advanced editor, copy and paste text from advanced editor and I will add the step for you.
- maitreyee8 years agoNew Member
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"