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 of VpeDate and store date like this "12-03-2017" (mm-dd-yyyy) 

 

now on KPI card when i drag this vMotor_Paid expression this shows an error 

 

"Calculation error in measure 'Varaibles Table'[vMotor_Paid: DAX comaprison operations do not support 

comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values "

2 Replies

  • 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)