Full Quarter total when only one month is selected

[Anonymous]

We finished May's financial data, but June is the end of the 2nd quarter.   On my page, I have filtered to Year = "2019" and Month = "May".  One of my columns is "Quarter Budget".  I want this column, "Quarter Budget", to display the full 2nd quarter budget, not to be filtered down to just "May".

When I finish Septembers numbers and filter my report to just "September", I want this "Quarter Budget" column to display the full 3rd quarter budget.

Possible?

[Anonymous]

Looking for this identical solution. Let me know if you discover anything!

[Anonymous · Accepted solution]

I figured it out.  Change the (Dates[Quarter]) to Year, Month, Week..........  I need a column to show me the entire quarter total regardless if I have a slicer that is selecting only one month.

Total Projected Gross Profit QTR = 
    CALCULATE([Total Projected Gross Profit], ALL(Dates),VALUES(Dates[Quarter]))

[amergaman]

Hi! Do you think it's possible to find the previous quarter based on the Month Slicer as well?