Measure Calculation

[SJ_16]

Hi,

I want a formula within my measure to say

if Date_In equals Quota_Date then total_val

Is this possible please?

[ychaitanya]

have you tried

Sum(If( Data_In=Max(Quota_Date),Total_Val))

[jubarrosor]

Hi:

Sum({<Data_In={">=$(=max(Quota_Date))<=$(=max(Quota_Date))"}>} Total_Val)

Best Regards,

Juan P. Barroso