Calculating the values for the complete month based on date slicer

[aJ2]

Hi.

I want to calculate the target number based on the date slicer.

For example, the date range selected is 1st May 2018-23rd June 2018, then the output should be 1st May 2018-31st May 2018 + 1st June 2018-30th June 2018).

Likewise, if the date range selected is 1st March 2018-10th March 2018, the output should be the target of 1st March 2018-31st March 2018.

I have created a measure but it is only considering it for the current month-

revenue target = CALCULATE(SUM(data[targettarget]),MONTH('data'[date])=MONTH(TODAY()))

So when I change the date range to May, I can still see only the values for June.

Kindly guide.

[Stachu · Accepted solution]

try this

revenue target:=CALCULATE(SUM(data[targettarget]),PARALLELPERIOD(data[date],0,MONTH))

[v-yulgu-msft · Accepted solution]

Hi @aJ2,

You need a calendar table which is unrelated to data table, generateed by CALENDAR() function. 

revenue target =
CALCULATE (
    SUM ( data[targettarget] ),
    MONTH ( 'data'[date] ) >= MONTH ( MIN ( calendar[dates] ) )
        && MONTH ( 'data'[date] ) <= MONTH ( MAX ( calendar[dates] ) )
)

Best regards,

Yuliana Gu

[aJ2]

Hi @v-yulgu-msft and @Stachu

Thank you so much...

Both the solutions worked for me

[Stachu · Accepted solution]

try this

revenue target:=CALCULATE(SUM(data[targettarget]),PARALLELPERIOD(data[date],0,MONTH))