topic Re: Store fixed date in variable in DAX Commands and Tips

Store fixed date in variable

Bakhtawar — Wed, 19 Jun 2019 11:26:40 GMT

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 "

Re: Store fixed date in variable

Stachu — Wed, 19 Jun 2019 16:18:46 GMT

try this syntax:

vMotor_Paid =
CALCULATE (
    SUM ( Paid_excel[PAID_AMOUNT] ),
    FILTER ( Paid_excel, Paid_excel[PAID_DATE] = { [VpeDate] } )
)

Re: Store fixed date in variable

Bakhtawar — Thu, 20 Jun 2019 05:38:11 GMT

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)