Forum Discussion
Changing the date format in Pivot table (Power Pivot)
I am having trouble changing the date format in the pivot table loaded from Power Pivot. For normal pivot table, I can change the format in "Field setting" - Number Format. The Number Format opti...
I found a solution to my problem.
Need to create two additional columns in Power Pivot using:
- MonthYear = Format(Date, "MMM-YY")
- YearMonthNumber = Format(Date, "YYYYMM")
Sort on the MonthYear column with YearMonthNumber