Forum Discussion

CMSINFO's avatar
CMSINFO
Frequent Visitor
7 years ago
Solved

Date Format

Hi, I am new to Power BI, can anyone tell me how to add dates in the format JAN17, FEB17,MAR17? I don't see this format on Modeling -> Format.   Thanks!
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    7 years ago

    CMSINFO -

     

    As a calculated column you can format the date as:

     

    Column = FORMAT(Table1[Date],"MMMYY")
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    CMSINFO  You can convert the date fields using FORMAT function. Try adding a new column as below

     

    DateMMMYY = FORMAT(TableName[DateColumn],"MMMYY")
PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

CMSINFO  You can convert the date fields using FORMAT function. Try adding a new column as below

 

DateMMMYY = FORMAT(TableName[DateColumn],"MMMYY")