Creating a new column mm/yyyy based on a previous column dd/mm/yyyy

[Anonymous]

Dear all,

I have a date colum which is formated dd/mm/yyyy (for example: 18/05/2020) and I want to create a new costum date column in Power Query which takes only mm/yyyy (05/2020). This queries are from a database and every time a new date record is created, this new date record should be created automatically.

Regards,
Shpendi

[amitchandak]

@Anonymous 

new column = right([Date_Field],7)

in case you want a date

New Date = date(right([Date_Field],4),mid([Date_Field],4,2),left([Date_Field],2))

[Fowmy · Accepted solution]

@Anonymous 

Add the following as a Custom Column in Power Query

=Date.ToText([Date],"MM/yyyy")

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn