Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 "
try this syntax:
vMotor_Paid = CALCULATE ( SUM ( Paid_excel[PAID_AMOUNT] ), FILTER ( Paid_excel, Paid_excel[PAID_DATE] = { [VpeDate] } ) )
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |