Compare last 3months with last 6m

flippe — Tue, 29 Nov 2022 15:00:53 GMT

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?

Re: Compare last 3months with last 6m

v-yueyunzh-msft — Wed, 30 Nov 2022 01:49:40 GMT

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

topic Compare last 3months with last 6m in DAX Commands and Tips

Compare last 3months with last 6m

Re: Compare last 3months with last 6m