DateFrormat

[Anonymous]

Hi All,

I have a date column for 3 Years in the format 01/01/2019, need to display the month in short and the respective financial Year.

Example:  Current Format: 01/01/2019

              Required Format : Jan-19

Thanks,

chandra

[judspud · Accepted solution]

Hi @Anonymous 

Are your financial years simply the year of the date?

if so you can use the following formula;

Month Year = Format('Calendar'[Date],"MMM YY")

Where Calendar is the table name and Date is the column name

Hope this helps

Thanks,

George

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may also use Date.ToText to add a custom column in Query Editor.

[judspud · Accepted solution]

Hi @Anonymous 

Are your financial years simply the year of the date?

if so you can use the following formula;

Month Year = Format('Calendar'[Date],"MMM YY")

Where Calendar is the table name and Date is the column name

Hope this helps

Thanks,

George