Date format mmm-yy

[jcastr02]

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.  

[Anonymous]

Select the column and go to "column tools"

Change the Data Type as "Date"

set the Format as mmm-yy

[vanessafvg]

@jcastr02 can you post your code?

[jcastr02]

@vanessafvg sorry which solution? which code?

[VijayP]

Use this DAX in Report View instead of in power Query. 

ddmmm = FORMAT([Date],"MMM-YY")

[dmercier]

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]

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

[VijayP]

To get Date information you must have one date column

Without Date column you cant manage any Date Hierarchy

[jcastr02]

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

[VijayP]

You are in powerquery editor

Close and apply the power query editor and then

in Report view goto Sheet View and there Add new column 

In the new column you can write What i menetioned above.

In power query editor you cannot write DAX

[jcastr02]

@VijayP Same thing, column doesn't come up

[vanessafvg · Accepted solution]

@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?

[jcastr02]

@vanessafvg    That was it, I was trying to create a measure vs. a column!  Thank you for the help!