Calendar Filters slice

[Ritaf]

Good morning.

I desperarely need help

I have a report with date slicer from...to... , my users want to update last day automaticly by the refresh date. I uppdated the calendar table's end day for today() to make it warking.

No I have a problem to calculate measures which dates is after "today", for example i have a target's table whit target for economy for purchase manegers for all year month by month and i need to see their results related to full year, quarter, i tryed many formulas to make it happen , but it shows me just a target until today..

formulas whose i tried:

yearly_target = CALCULATE(TOTALYTD(sum('Targests'[Target $]),Targests[date],ALLCROSSFILTERED(dimDate)))

yearly_target = CALCULATE(TOTALYTD(sum('Targests'[Target $]),Targests[תאריך],ALLEXCEPT(dimDate,dimDate[year])))

yearly_target = CALCULATE(TOTALYTD(sumx(Targests,Targests[Target $]),dimDate[date]),ALLEXCEPT(dimDate,dimDate[year]))

TargetQ =

CALCULATE(sumx(Targests,'Targests'[Target $]),

year('dimDate'[date])=year(today()),

'dimDate'[QuarterNumOfYear]=ROUNDUP(MONTH(today())/3,0))

Link for pbix:

https://sabercathost.com/dOV7/consulting_model.pbix

thank a lot, 

Rita

[amitchandak · Accepted solution]

Can you try setting the date in slicer using relative and advance setting and try. make calendar full..

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

[amitchandak · Accepted solution]

Can you try setting the date in slicer using relative and advance setting and try. make calendar full..

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

[Ritaf · Accepted solution]

Thanks a lot it solved my problem!!!!!!!!!!!!!!!!!!