Data conversion

[Sentinel997]

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

[speedramps · Accepted solution]

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. 😀