Forum Discussion

Bakhtawar's avatar
Bakhtawar
Post Patron
7 years ago

Store fixed date in variable

Hi all  i write this expression and there is not any errors in this  vMotor_Paid = CALCULATE(SUM(Paid_excel[PAID_AMOUNT]),FILTER(Paid_excel[PAID_DATE]={[VpeDate]})) Here I create another variable ...
Stachu's avatar
Stachu
Community Champion
7 years ago

try this syntax:

vMotor_Paid =
CALCULATE (
    SUM ( Paid_excel[PAID_AMOUNT] ),
    FILTER ( Paid_excel, Paid_excel[PAID_DATE] = { [VpeDate] } )
)
Bakhtawar's avatar
Bakhtawar
Post Patron
7 years ago

Hi when i try to add more filters this shows nothing  i tried this 

vMotor_Paid = 
CALCULATE (
    SUM ( Paid_excel[PAID_AMOUNT] ),
    FILTER ( Paid_excel, Paid_excel[PAID_DATE] = { [VpeDate] } ),
FILTER(Premium_Excel,Premium_Excel[LOB] = "MOTOR"),
FILTER(Paid_excel,Paid_excel[Flag] = "Paid"))

and in VpeDate i add date like this 

VpeDate = date(2017,12,31)