Forum Discussion
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.
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?
12 Replies
- Use this DAX in Report View instead of in power Query.ddmmm = FORMAT([Date],"MMM-YY")
To get Date information you must have one date column
Without Date column you cant manage any Date Hierarchy
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?
jcastr02 can you post your code?
vanessafvg sorry which solution? which code?
