Get data for previous 8(Current + Previous 7 quarters) data based on slicer selection

binayjethwa , if you select 1 value and want to show more than that, then you need slicer of independent date /qtr table

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -24) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE

Hi amitchandak ,

I do not have any date field in my model , i Just have a Quarter and Year slicer separately , and based on selection i need to show my calculations for 8 previous quarters.

1) We need to create a column (Index)

2) also need to create two unrelated tables

3) need to correctly insert slicer and matrix columns

4) create measure

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rhj6wb7rJPiGmynJB?e=vWbuxT

Hi Ahmedx  ,

Are those Year and Quarter slicers are taken from DimYear and DimQuarter tables ?

If it is taken from those disconnected tables , how can i get other KPIS to get filtered out since there are other KPIS on the page which gets filtered based on slicer selection.