Using date

[dave_schultz]

Hi there,

I would like to subtract two days from the most recent PRICE_DT field, but i'm getting an error. Here's my code:

let
Source = #"Curated RP_IOSAF_TRANSACTIONS",
#"Extracted Date" = [PRICE_DT].From(Source),
#"Converted to Table" = #table(1, {{#"Extracted Date"}}),
#"Added Custom1" = Table.AddColumn(#"Converted to Table", "Custom.1", each Date.AddDays([Column1],-2)),
just_the_value = #"Added Custom1"{0}[Custom.1]
in
just_the_value

I'm getting this error: "Expression.Error: The name 'PRICE_DT.From" wasn't recognized. Make sure it's spelled correctly. 

[dave_schultz · Accepted solution]

Hi @Anonymous -

Thanks for responding. i ended up getting some help internally at my firm. I ended up duplicating the original query removing all data except for the date i wanted. then i removed duplicate dates and sorted on newest to oldest. Then i added an index and had my other query reference the date that i wanted in my query. It worked! 

Thanks again! 

David

[Anonymous]

Hi @dave_schultz ,

It's glad to hear that your problem has been resolved. And thanks for sharing your solution here. Thank you.

Best Regards

[Anonymous]

Hi @dave_schultz ,

According to the error message, it seems the error occur at the second step #"Extracted Date"... Could you please provide some sample data in your table and the screenshot with error message in Power Query Editor? Thank you.

Best Regards