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

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... :(