Forum Discussion
Data conversion
Hi
I'm looking for a way in PowerQuery to switch data.
Data from Source: 1220527
But it has to be a date: 27.05.2022
Does anyonehave a solution for me?
Thanks
Hi Sentinel997
If you are a Power Bi novice then try this method ...
Edit your data source query table in Power Bi and click on the 1220527 column.
The click on Add column > Column From Examples.
Input 22.05.2020 i the Custome column
Repeat for a few more rows until Power Bi guesses all the other rows correctly.
It may tale a two or few attempts.
Please click the thumbs up and accept as solution buttons. 😀
1 Reply
Hi Sentinel997
If you are a Power Bi novice then try this method ...
Edit your data source query table in Power Bi and click on the 1220527 column.
The click on Add column > Column From Examples.
Input 22.05.2020 i the Custome column
Repeat for a few more rows until Power Bi guesses all the other rows correctly.
It may tale a two or few attempts.
Please click the thumbs up and accept as solution buttons. 😀