Forum Discussion
ImalkaJ
Oct 06, 2021Copper Contributor
Order month name by calendar sequence
Hi Excel experts, This is Excel 365. I use Power query to get data and there is a column in data format. I want the calendar month in a slicer 1) I used Month.name on Power query to derive the ...
- Oct 07, 2021
In PivotTable where data is adding to data model add one more column to the table in Power Pivot
next Month
and sort Month by Month Number
SergeiBaklan
Oct 06, 2021Diamond Contributor
ImalkaJ
Oct 06, 2021Copper Contributor
Hi , thanks for looking into this. I am applying it to a pivot table.
- SergeiBaklanOct 07, 2021Diamond Contributor
In PivotTable where data is adding to data model add one more column to the table in Power Pivot
next Month
and sort Month by Month Number
- ImalkaJNov 03, 2021Copper ContributorThanks! This worked
- SergeiBaklanNov 04, 2021Diamond Contributor
ImalkaJ , glad it helped