topic MMDD and YY columns in DAX Commands and Tips

MMDD and YY columns

Anonymous — Mon, 23 May 2022 21:59:42 GMT

Hello Everyone,

I have 2 columns below, how can I convert them to a proper date format like 1/4/2021? Thanks in advance.

Re: MMDD and YY columns

Nathaniel_C — Tue, 24 May 2022 01:22:33 GMT

Hi Anonymous ,

Go to Power Query - Split the column by the 2 right characters, join the three columns with "/" and change to date.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Re: MMDD and YY columns

Nathaniel_C — Tue, 24 May 2022 01:26:27 GMT

Re: MMDD and YY columns

Nathaniel_C — Tue, 24 May 2022 19:16:29 GMT

Hi Anonymous ,

If this solves your issues, please mark it as the solution, so that others can find it easily.
Nathaniel

Re: MMDD and YY columns

Anonymous — Tue, 24 May 2022 19:50:53 GMT

Thanks so much, it works Nathaniel_C

Re: MMDD and YY columns

Nathaniel_C — Tue, 24 May 2022 19:58:11 GMT

Hi Anonymous ,

You are welcome!

Nathaniel