Power BI
CompletedPower Query, convert date fields to monthname, weekdayname, quartername
Terje Fjeldstad on 08 May 2015 00:21:57
When using power Query to add columns based on A date field, it would be Nice to also be able to convert to month name, not just month number. Example; 31.01.2012 should have built-in function to set december or dec....monday or mon. Till now, we can only get numeric values.
Administrator on 02 Jul 2016 00:11:43
I'm glad to report that this transformation is now available in the June Update of Power BI Desktop: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-update/ Extract Week Day and Month Name from a DateTime column Another very common customer request has been to provide a built-in transformation to extract the WeekDay or Month names from a given Date/Time column. We’ve made this available from the Query Editor ribbon (either via Transform to modify an existing column, or via Add Column to insert a new one). These two options can be found under “Date -> Day -> Name of Day” and “Date -> Month -> Name of Month”, respectively. Note that the Day/Month names are localized according to the Locale setting for your Power BI Desktop file (available under File -> Options -> Current File -> Regional Settings).
- Comments (23)
RE: Power Query, convert date fields to monthname, weekdayname, quartername
You also can try this: =FORMAT([date],"MMM") BUT it will order it by month name, not by month number......
RE: Power Query, convert date fields to monthname, weekdayname, quartername
Terje,
You can add a custom column with this formula to =Date.ToText([Date],”MMM”) to return the month name.
RE: Power Query, convert date fields to monthname, weekdayname, quartername
I agree! Meanwhile, any hints on how to use a List function (List.Select?) to transform integer to monthname?