Comparing between periods

Question

Hi&nbsp;I want to compare the selected period to the parallel period, but like this graph:I like the chart will add the 2021 Q4 Oct with the capital, recurring, and Rent... amounts in the parallel period like this:&nbsp;Can I do that?Thanks

amitchandak · Accepted Answer

mottya , I that can slicer need to be on an independent date table 
&nbsp;
//Date1 is independent Date table, Date is joined with Table new measure =var _max = maxx(allselected(Date1),Date1[Date])var _min = minx(allselected(Date1),Date1[Date])
var _max1 = date(year(_max)-12, month(_max) , Date(_max) )
var _min1 = date(year(_min)-12, month(_min) , Date(_min) )return calculate( sum(Table[Value]), filter('Date',&nbsp; ('Date'[Date] &gt;=_min &amp;&amp; 'Date'[Date] &lt;=_max) ||&nbsp;
('Date'[Date] &gt;=_min1 &amp;&amp; 'Date'[Date] &lt;=_max1)
) )
&nbsp;
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

Forum Discussion

Related content

Using Measure to Compare Current Period to Previous Period

Compare Against Previous Period KPI Card

Compare data with previous period/last month

New and lost Sales comparing periods

Compare MTD with previous period