I would like to calculate the devices deployed per Quarter so I have created a pivot table.
The problem comes when I select more than one quarter. The InstallationDate Date range is wrong due to min/max dates which are 6 months (if I select 2 quarters), 9 or 12 depending on the number of quarters selected.
I wish that adding a picture was good enough to understand the whole data model and the issue you are running into. Unfortunately, it isn't. Unless you are able to share sample or sample data with expected output, I am afraid I won't be able to offer much help.
Attached the data model where I have a master calendar and the Fact table where SerialNbrItemQty and InstallationDate are.
Filtering only by Q4 it shows correct results because the Date range is getting min/max MonthYear values for 3 months. However, if I filter by Q3 and Q4 min/max values take now 6 months range instead of first 3 for Q3 and second 3 for Q4 so numbers are incorrect.
I have added columns >= and < per quarter to check if the set analysy was calculating date ranges per quarter as expected, and it is. Don't know why it's taking both quarters as the date range for both Q3 and Q4 then.