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

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

  • VijayP's avatar
    VijayP
    Community Champion
    6 years ago

    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's avatar
      jcastr02
      Post Prodigy
      6 years ago

      VijayP Same thing, column doesn't come up

      • vanessafvg's avatar
        vanessafvg
        Community Champion
        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?