Forum Discussion
I need Help With A Date Formula
Wow this is a lot, thank you dufoq3, I am sorry but could you make it like this code below
= Table.AddColumn(#"Added Custom10", "Test Close Date formula", each if [Deal Stage] = "Won" then
if [Close Date] = null or [Close Date] = "" then
if [Est Close Date] = #date(2023) then [Est Close Date]
else if [Est Close Date] = #date(2024) then Date.From(DateTime.LocalNow())
else if [Est Close Date] = null or [Est Close Date] = "" then Date.From(DateTime.LocalNow())
else null
else [Close Date]
else null)
This was from me trying to do it with POE and of course it failed but I don't know how to apply your code
Heve you read note below my post?
sorry I just saw it, but it seems that I can't get my query is this because I use Dynamics 365 online to connect the dataset?
I think I figured it out, sorry this is my first time using Power Query so please be patient with me
when I changed the query as you said in the note the code worked but it gave me an error in the new column rows when I clicked the error it said this
Expression.Error: The column 'Value' of the table wasn't found.
Details:
Value
I think this is because the true value name in my data set is not the same the only problem is I have nearly 400 columns in the dataset do I need to identfy them all?
You have Value column in your sample data. Which step cause an error? ChangeType?