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
use "try....otherwise".
try <some code hear that may result in an error> otherwise <run this code in case of error>
note that try and otherwise are NOT capitalized. Also, no commas are needed.
Hi 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"Hi Bekah,
this works perfect - thank you very much...Best wishes
