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