Compare last 3months with last 6m

[flippe]

Hi all,

Here's my sample:

I need to sum up the last 3 month views (green rows) and compare it against the last 6 months views (from August to June - yellow rows).

At the moment, the sum of 3 months views is working properly:

Previous 3M views =

CALCULATE(

    [Total Views],

    DATESINPERIOD(

        Calendar[Date],EOMONTH(TODAY(),-1),-6,MONTH)

        )

How can I accomplish the sum of the yellow rows?

[v-yueyunzh-msft · Accepted solution]

Hi, @flippe 

According to your description, you want to calculate “the last 6 months views”. Right?

Here are the steps you can refer to:

(1)This is my test data:

(2)I create a date table like yours and create relationships between two tables:

(3)Then we can create a measure :

Previous 6M views = var _current_date =EOMONTH( MAX('Calendar'[Date]) , 0)
var _previous_months = EOMONTH(_current_date,-6)+1
var _t= FILTER( ALLSELECTED('Table') , 'Table'[Date] >= _previous_months  && 'Table'[Date] <= _current_date)
return
SUMX(_t ,[Value])

(4)Then we can put this on the visual and we will meet your need:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly