Forum Discussion
jcastr02
Post Prodigy
Post ProdigyDate 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?
Select the column and go to "column tools"
Change the Data Type as "Date"
set the Format as mmm-yy