how to show end of Quarterly figures

[ShelRose]

Hi, 

I'm trying to show end of quarterly values in a Donut chart but not all figures added up. i need it to show

Q1=3482

Q2= 3350

and so on.

Jan	3587
Feb	3551
Mar	3482	Q1
Apr	3477
May	3403
Jun	3350	Q2
Jul	3355
Aug	3346
Sep	3514	Q3
Oct	3493
Nov	3491
Dec	0	Q4

Is this possible to show? thanks in advance 

[Sahir_Maharaj]

Hello @ShelRose,

Can you please try this:

1. Create a Quarter Identification Column

Quarter =
SWITCH(
TRUE(),
MONTH([Date]) <= 3, "Q1",
MONTH([Date]) <= 6, "Q2",
MONTH([Date]) <= 9, "Q3",
"Q4"
)

2. Create a Measure for End-of-Quarter Values

End of Quarter Value =
CALCULATE(
SUM([Value]),
FILTER(
ALL('Table'),
'Table'[Quarter] = MAX('Table'[Quarter]) &&
'Table'[Month] = EOMONTH(MAX('Table'[Date]), 0)
)
)

Should you require any further assistance, please do not hesitate to reach out to me.