Forum Discussion
RanHo
Helper V
Helper VPOWERBI : TARGET ON MATRIX
Good day! I just want to ask if its possible, I have problem sample here: I want to show the changes of target depends on filter months. Is it possible or is there oth...
amitchandak
Super User
Super UserRanHo , You can create a measure like ,
measure =
var _max = Maxx(allselected(Table), Table[Date])
return
if(isfiltered(Table[Date]), calculate(sum(Table[Target]), filter(Table, eomonth(Table[Date],0) = eomonth(_max,0))) ,sum(Table[Target]))
Make sure you create a date using month
RanHoHelper V
Helper Vamitchandak I just update my sample data, I can't do the formula you gave me coz the data/ sample I gave is incomplete, hope it helps.