Solved: m code - mmm-yy

jcastr02 · ‎01-11-2021

How can I get a column added in format "MMM-YY" using M Code. I able to do via DAX, but need for m code.

Fowmy · ‎01-11-2021

@jcastr02

Add the following as a custom column:

=Date.ToText([Date],"MMMM-yy")

________________________

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

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

Did I answer your question? Mark my post as a solution! and hit thumbs up

Energykeith · ‎05-13-2024

You can also use =Date,"mmmm-yy"

Fowmy · ‎01-11-2021

@jcastr02

Add the following as a custom column:

=Date.ToText([Date],"MMMM-yy")

________________________

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

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

Did I answer your question? Mark my post as a solution! and hit thumbs up

m code - mmm-yy