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