Forum Discussion
Two timezone in the same column from the same source
Isn't this what you wanted? The error message text extracted out?
If you also want the details, you can change [Message] to [Detail]. Note that [Detail] is not a string, it is a record.
If your refering to my first post, I think I had a minor bug... just change
"DD-MM-YYYY"to
"DD/MM/YYYY"
Well you might be able to, or you just do it directly in Power Bi like:
= Table.TransformColumns(PreviousStep, {"DateColumn", each Date.FromText(_, if Text.Contains(_, "-") then "YYYY-MM-DD" else "DD-MM-YYYY")})This will need modification based on your:
DateColumn
PreviousStep
Well, now there's only errors.
Is there a way to extract the text of an "error" cell. Because the very first step (source) is filled with errors.
Thank you
You can, but is that what you want to do?
You can add a new column with:
let val = try [DateColumn]
in if val[HasError] then val[Error][Message] else val[Value]
Isn't this what you wanted? The error message text extracted out?
If you also want the details, you can change [Message] to [Detail]. Note that [Detail] is not a string, it is a record.
If your refering to my first post, I think I had a minor bug... just change
"DD-MM-YYYY"to
"DD/MM/YYYY"