Forum Discussion
Error Message Measure in PBI ( Urgent Please )
Revenue =
Var CODFees = IF(
AND(deliveries[sender._id] = "UiMNuYTbVmn",deliveries[cod.amount]>0),deliveries[pricing.priceBeforeVat]+7
,deliveries[pricing.priceBeforeVat]
)
RETURN
IF(
deliveries[sender._id] = "UiMNuYTbVmn",
CODFees,
deliveries[pricing.priceBeforeVat] - deliveries[pricing.expediteFee.amount]
)
Give me error :
DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.
Can anyone support urgently
Hi AliBiktash99
The "cod. amount" / other variable is a text...
Please check the data types and change them to numbers :
1 Reply
- Ritaf1983
Super User
Hi AliBiktash99
The "cod. amount" / other variable is a text...
Please check the data types and change them to numbers :