Forum Discussion

bilalkhokar73's avatar
bilalkhokar73
Helper IV
5 years ago

Target Month slicer issue

When i select Slicer for june month then it gives me results for July month , but when i select july month then result is coming right, but when i select a range of month then worng results,
I have my target table , target table Salesman id joined with salesman code, target month and year with date table 

Target= TOTALMTD(SUM(TargetM[targetvalue]),TargetM[Montyear_TGT] )

I created a column 
Montyear_TGT = DATE(T_TargetM[target_year],T_TargetM[target_month],01)

2 Replies