Need help to create a calculation from a time period and then year on year

[ballist1x]

Help i am trying to calculate a number from the following that uses a pecific date range ro vcreate a calculation:

I am doing this wrong but i am trying to calculate the 'final amount (£) for April 2017-July 2017

and then again for April 2018 - July 218

Measure = CALCULATE(sum(H12015[Final Amount (£)], FILTER(ALL(H12015[Posting Date].[Month]April), H12015[Posting Date].[2017]).....

if you can assist.

[v-juanli-msft · Accepted solution]

Hi @ballist1x

First create calculated columns

month =
MONTH ( [Posting Date] )

year =
YEAR ( [Posting Date] )

Then create a measure

Measure =
CALCULATE (
    SUM ( Sheet1[Final Amount (£)] ),
    FILTER (
        ALLSELECTED ( Sheet1[year] ),
        SELECTEDVALUE ( Sheet1[month] ) > 3
            && SELECTEDVALUE ( Sheet1[month] ) < 7
    )
)

Best Regards

Maggie

[ballist1x]

@v-juanli-msft

i used this, does it give the same resolt?

CALCULATE(SUM(H12015[Final Amount (£)]),FILTER(ALL(H12015[Posting Date]),[Posting Date] >= DATE(2017,6,1) && [Posting Date] <= DATE(2017,7,1)))

[v-juanli-msft]

Hi

This formula will calculate the "final amount (£) from June 1st 2017-July 1st 2017"