Date Formatting in Calendar Table from yyyy 2021 and month Nov to Nov-21

[PBI-Curious]

Hello PB Community Good Day

Looking to update my Calendar Table with the following:

from yyyy 2021 and month Nov to Nov-21

Much appreciate your time

Thank You

[PBI-Curious · Accepted solution]

Hello

If I wanted to create a new column in a table what would the logic be. I don't have a date in the table below.

Regards,

[PBI-Curious · Accepted solution]

Hello

If I wanted to create a new column in a table what would the logic be. I don't have a date in the table below.

Regards,

[ValtteriN · Accepted solution]

@PBI-Curious 

With month and YYYY columns it would go like this:
CustomFormat = FORMAT(DATE('Table'[Year],'Table'[Month],1),"MMM-YY")

[ValtteriN]

Hi,

This logic should do this:

CustomFormat = FORMAT(DATE(YEAR('Calendar'[Date]),MONTH('Calendar'[Date]),1),"MMM-YY")

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

[PBI-Curious]

Hello ValtteriN

Much appreciate your help!

Thank you