Forum Discussion

cyborgandy's avatar
cyborgandy
Icon for Helper II rankHelper II
4 years ago

12 Month Rolling Attrition Graph Issue

Trying to show the attrition for the last 12 month rolling on bar chart in power BI. Sum of attrition for the last 12 months / average HC for the last 12 months.   The X axis for this graph should...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

cyborgandy , If you choose one month and what show more than that data on axis, ou need independent date table in slicer

 

example measure

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

 

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI