Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago
Solved

Date format mmm-yy

Hello I am trying to use format DAX to convert to a mmm-yy format, but the column with the date is not coming up which is completion time when I try to enter it into DAX formula.    
Need Help
  • vanessafvg's avatar
    vanessafvg
    6 years ago

    jcastr02 are you creating a new column or a new measure?  So you create completion time in the query editor, you then push it to the visual pane and now you are trying to format that field in DAX but when you create a new column you can't see the date?  Are you sure you creating a new column and not a new measure?

VijayP's avatar
VijayP
Community Champion
6 years ago
Use this DAX in Report View instead of in power Query. 
ddmmm = FORMAT([Date],"MMM-YY")
  • jcastr02's avatar
    jcastr02
    Post Prodigy
    6 years ago

    VijayP   The date column will not come up for me to choose

    • VijayP's avatar
      VijayP
      Community Champion
      6 years ago

      To get Date information you must have one date column

      Without Date column you cant manage any Date Hierarchy

      • jcastr02's avatar
        jcastr02
        Post Prodigy
        6 years ago

        VijayP   I have column with date (completion time)  see 1st pic above and the format is set to date and time

  • dmercier's avatar
    dmercier
    Frequent Visitor
    5 years ago

    Hi Vijay, This worked great.  However it stores the data in the field as TEXT and if I change it to DATE, I get ERROR message.  If it's not a DATE, I cannot use it in a trend chart graph?