Forum Discussion
Power Query M code equivalent to "iferror" function
Hi,
Please can you tell me the Power Query M code equivalent for the "iferror" function in excel?
Thanks,
CM
6 Replies
Hi Anonymous,
Related documentations: https://msdn.microsoft.com/en-us/library/mt186368.aspx and https://msdn.microsoft.com/en-US/library/mt267542.aspx.
Best Regards!
Dale
Hi Anonymous,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.Best Regards!
DaleHi all,
unfortunately this doesn't solve my issue.- There's a textfield, with e.g. 01.02.2019 - 28.02.2019
- I divide this column into column A (startdate): 01.02.2019 and column B (enddate): 28.02.2019
- Now it can happen, that there is 01.02.2019 - 30.02.2019 written
- Due 30.02.2019 definitively an error occurs
If something like (4) happens, in column B must be written 31.12.2030 (e.g) and in a third column "check supplydate".
How can I fix this?
Maybe iferror / try.....otherwise is the wrong idea?
Thx in advance for your help.
Anonymous try this:
let Source = Table.FromList({[TextField ="02.01.2019 - 02.28.2019"],[TextField ="02.01.2019 - 02.30.2019"]},Record.FieldValues, {"TextField"}), #"Added StartDate" = Table.AddColumn(Source, "StartDate", each try Date.FromText(Text.BeforeDelimiter([TextField], " ")) otherwise Date.FromText("12/31/2030")), #"Added EndDate" = Table.AddColumn(#"Added StartDate", "EndDate", each try Date.FromText(Text.AfterDelimiter([TextField], " ", 1)) otherwise Date.FromText("12/31/2030")), #"Added Action" = Table.AddColumn(#"Added EndDate", "Action", each if [StartDate] = Date.FromText("12/31/2030") or [EndDate] = Date.FromText("12/31/2030") then "check supplydate" else "") in #"Added Action"
