Forum Discussion

gdexter's avatar
gdexter
Frequent Visitor
8 years ago

Format Date Naming IMPOSSIBLE?

Dear Power BI Community,   Reaching out for help,   Below we have a list of dates. I would like to create a new column that simply contains the MONTH and YEAR information, in a "January 2016" for...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi gdexter

 

If you select the date column in FIelds panel, and then go to Modelling-> Format->Date Time-> There you have this format as a standard option. You can select MMMM,yyyy format which will display the date like January,2018 etc.

 

Thanks

Raj

Anonymous's avatar
Anonymous
Not applicable
8 years ago

If you need this in DAX, Please use this code.

 

New_Date_Column= FORMAT(Table1[Date],"MMM-yyyy")

 

Thanks

Raj

  • gdexter's avatar
    gdexter
    Frequent Visitor
    8 years ago

    Hi Anonymous 

     

    Thank you for the suggestion.

     

    When I enter FORMAT using your formula, the formula errors if enter the my date table and column.

    ERROR MESSAGE:

    A single value for column 'Daily' in table 'Date' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

     

    Perhaps it will work using a Power Query instead.

    Do you know how I can do this in Power Query using M Language?

     

    Thanks,

    Gdexter

    Giovanni

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Try the formula in calculated column.

       

      Thanks

      Raj

      • gdexter's avatar
        gdexter
        Frequent Visitor
        8 years ago

        Anonymous I have tried it in Power Query and as a measure. Both times it bounces back with an error... :(