How to Convert Month Number to Name in Power Query

#Shorts
You will learn a short M function to convert months number to Name in Power Query.

[faith_oseghale]

Very Direct. Thank you.

How did you come up with the 29 though?

[zeonix]

Many thanks for your video!! Amazing solution!!

[paulrobb]

Thanks so much, everything else I was trying to do wasn't working. This solved it for me :)

[lassejrgensen]

only took an hour to find this solution. THANK YOU!

[dacomaco]

Wow, thank you. Why do you multiply for 29?

[taringnima]

if you want to make video make it clear, don't waste others time!

[anyam]

Sorry, can't see the typed formula

[zxyzxyzyzyugfd]

thanks for the video. My issue is i have 2 column : In the first i have month number 1, and in the second 2021. I want to create a third column which gives me full date end of month: 31.01.2021. Thanks for your help.