Hi everyone, The error on row 23 was a result of Doug change the text "Friday April 27 2018..." to "Friday April 27 2017...". This is not a valid date, 27 April 2017 is a Thursday. It has nothing to do with bottom up.
Thanks for the video!! I have a similar example where date is stored as text with a format “DD.MM.YYYY” like so ->>> 31.12.2018 How can this be transformed to MM/DD/YYYY?
That worked like a charm 👌🏻👍🏻 We need to be mindful, though, about the order in which columns to be selected as this would be the driver for merge query.
Very informative video sir thanks a lot.
Most welcome!
Legal, o power query é uma ferramenta incrível, obrigado.
Olá Luciano Moreira, de nada!
Great and helpful video
thanks for the comment!
Bottom top is something new and strange. Thanks for your video.
You're Welcome!
Like Lofty said: Bottom Up!!! : )
Thanks Mike!
Hi everyone,
The error on row 23 was a result of Doug change the text "Friday April 27 2018..." to "Friday April 27 2017...". This is not a valid date, 27 April 2017 is a Thursday. It has nothing to do with bottom up.
Hi Chee Foong Chan, thanks for adding to the thread!
Thanks for the video!!
I have a similar example where date is stored as text with a format “DD.MM.YYYY” like so ->>> 31.12.2018
How can this be transformed to MM/DD/YYYY?
you can try to split it to separate columns with the "." as the delimiter and then merge back together with the /
That worked like a charm 👌🏻👍🏻
We need to be mindful, though, about the order in which columns to be selected as this would be the driver for merge query.