Forum Discussion
Try Otherwise in M (Error Replacement)
Hello, I got a question. I got a lot of errors because the date field is empty. So I thought a error handling with try otherwise could help me out but how can I implement it? (I just put in 1 col...
It was easier then i thought
#"Replace Error" = Table.ReplaceErrorValues(#"Geänderter Typ", {{"Pat-Geb-Datum", ""}})But is there a way to make a for each loop for all columns with dates in the whole table?
It was easier then i thought
#"Replace Error" = Table.ReplaceErrorValues(#"Geänderter Typ", {{"Pat-Geb-Datum", ""}})
But is there a way to make a for each loop for all columns with dates in the whole table?
Select all the columns you want to transform and then click on replace errors