Only calculate the number at the end of the quarter

[BigKev]

Hi All,

Does anyone know how I can only look at the number at the end of the quarter for my quarter to Quarter calculations?

This is my data 

	Q1			Q2
Mnth	1	2	3	4	5	6
A	112	112	112	112	112	112
B	10	10	7	2	2	2
%	9%	9%	6%	2%	2%	2%

So my Q1 number should only look at March value, instead of having to sum column A (Jan - Mar)/ sum column B ( Jan - Mar). Same for Q2 and future quarter.

Cheers,

Kev

[jdbuchanan71 · Accepted solution]

@BigKev 

Give something like this a try.

EoQ = CALCUALTE ( [Your Measure], KEEPFILTERS ( Dates[Mnth] IN {3, 6, 9, 12} ) )