Quarter calculation help

[JS]

Hi All.   I want to create a calcuation that will calculate the entire quater even though I have only selected a single month selection.

For example - I have selected May in my filter, the calculation will calculate the total sum of of Q2 (Apr, May & June). Is there anyway I can get this calculation out? Thanks. 

[v-yulgu-msft]

Hi @JS,

Have you worked it out? If so, would you please mark the helpful reply as an answer or kindly share your solution so that it can benefit more users? If you still have any question, please feel free to ask.

Thanks,
Yuliana Gu

[v-yulgu-msft]

Hi @JS,

Suppose there existing a Quarter column in source table. Now, you need a date table which contains one continual date column, and a Month column and a Quarter column. Don't need to create relationship between these two tables.

Add Month column from date table into slicer. Create a measure as below:

Sum per quarter =
CALCULATE (
    SUM ( SourceTable[Amount] ),
    FILTER ( ALL ( SourceTable ), SourceTable[Quarter] = LASTNONBLANK ( DateTable[Quarter], 1 ) )
)

Regards,
Yuliana Gu

[Greg_Deckler]

If, in your calendar month table you have a Quarter column and this specified, then you could do something like:

Measure = CALCULATE(SUM([Column]),ALLEXCEPT(Table,Table[Quarter]))

This would ignore all context except Quarter. I think that will get you what you want but I don't have your data.