If you don’t have that icon in Power Query, you can use the Custom Column icon and build a formula. The Column From Examples functionality was added for Office 365 customers last year. The formula bar will reveal a formula of Date.MonthName(). Repeat the Column From Examples technique to get a column containing the month name. But since Column From Examples generates the formula itself, you don’t have to worry about remembering the proper capitalization. But in Power Query, you have to use the appropriate capitalization. In Excel, a formula could be typed as =text(A2,“DDDD”), as =TEXT(A2,“dddd”), or even as =TeXt(a2,“ddDd”) and return the results. This formula illustrates one thing that can be frustrating for Excel veterans: Formulas in Power Query are case-sensitive. The formula bar will show the Power Query function used to create the column: Date.DayofWeekName(). Press Enter, and a new column will be added to the data preview window showing the corresponding weekday for each date in the table. Type “Monday” in the box, and Power Query will suggest “Day of Week from Date.” Column From Examples creates a new Column1 on the right side of the screen. The date in the first row of data is January 1, 2018, which was a Monday. On the Add Column tab, choose Column From Examples.

Click on the heading for the Date column. In the Get & Transform Data section, click on From Table/Range. Then, with one cell in the data selected, go to the Data tab. Go to Home, Format as Table to declare the data as a table. Start with a data set that includes a date column. Unfortunately, this feature is limited to Windows versions of Excel 2016 and later. The new Column From Examples feature in Power Query provides a new, more effective solution. In the past, you might have used formulas such as =TEXT(A2,“DDDD”) to add a new column to your source data to return the weekday.

Excel pivot chart how sort axis values