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
  • 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")

8 Replies

  • ChrisMendoza's avatar
    ChrisMendoza
    Resident Rockstar
    7 years ago

    CMSINFO -

     

    As a calculated column you can format the date as:

     

    Column = FORMAT(Table1[Date],"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")
    • CMSINFO's avatar
      CMSINFO
      Frequent Visitor
      7 years ago

      Thanks! It worked however now the columns are in alphabetical order not on cronological order, how to sort it out?

      • PattemManohar's avatar
        PattemManohar
        Community Champion
        7 years ago

        CMSINFO Add an another new column (if table doesn't have one as below) and call it as SortKey

         

        SortKey = FORMAT(Table[DateColumn],"YYYYMM")

         

        Select the field that you want to sort on (in this case it is the field that you have created earlier i.e. MMMYY format) then click on "Sort By Column" option under "Modelling" tab use SortKey field