Forum Discussion

binayjethwa's avatar
binayjethwa
Icon for Helper V rankHelper V
3 years ago

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

Hi,   I want to show the line chart which shows the last 8 quarters of data ( selected quarter + previous 7 quarters data) based on slicer selection.   I have a simple data table without date fie...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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