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")
CMSINFO's avatar
CMSINFO
Frequent Visitor
7 years ago

It sorted the column in the Data but my report remains in alphabetical order, why?

  • CMSINFO's avatar
    CMSINFO
    Frequent Visitor
    7 years ago

     

    The months on my matrix still in alphabetical order...

     

    • ChrisMendoza's avatar
      ChrisMendoza
      Resident Rockstar
      7 years ago

      CMSINFO -

       

      Is your calculated column [MMMYY] in the 'Date' Table (a proper date table) and the fact table with measures/etc. related to that 'Date' Table? Or are you trying to do all this within the fact table?

       

      I'm guessing you need to share more of your model cause what's been suggested should work.

       

       

      Fact Table