Nov 08 2021 07:00 AM
Nov 08 2021 07:59 AM
That's better to create separate table with months (even better to use calendar), add this table to data model, build relationships
and use months from this table both in PivotTables and Slicers.
Nov 08 2021 08:04 AM
Nov 08 2021 01:36 PM
Better to work with actual dates. In simplest case create table like
add it to data model and in Power Pivot add two columns
and
Select [Month] and Sort By month number
Create 1:M relationships on Month from date column to your other tables. Create PivotTables and use [Month] from Date table in it. It's a best practice to hide field which is on many side of relationship.
I didn't touch your file with above, perhaps it's better to repeat from scratch with Date table.
Nov 08 2021 04:11 PM