Forum Discussion

ImalkaJ's avatar
ImalkaJ
Copper Contributor
Oct 06, 2021
Solved

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 ...
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 07, 2021

    ImalkaJ 

    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

Resources