topic Date Formatting in Calendar Table from yyyy 2021 and month Nov to Nov-21 in DAX Commands and Tips

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

Anonymous — Thu, 27 Jan 2022 17:01:38 GMT

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

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

ValtteriN — Thu, 27 Jan 2022 17:12:32 GMT

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!

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

Anonymous — Thu, 27 Jan 2022 17:34:16 GMT

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,

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

ValtteriN — Thu, 27 Jan 2022 18:19:04 GMT

Anonymous

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

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

Anonymous — Thu, 27 Jan 2022 18:29:45 GMT

Hello ValtteriN

Much appreciate your help!

Thank you