Forum Discussion
Solved
Calculated Column with multiple conditions
Hi all, Am trying to calculate a cost column based on multiple conditions but it seems like the last step where I need to calculate the results from coulmn values throws the whole thing off. When I...
ryan_mayu
I figured out where I was going wrong. I was comparing a numeric column('Order'[Document.orderDetails.totalMileage]) to text "12". Once I changed "12" to 12, everything worked. You mentions of numeric and text prompted me to review the query and then I was able to see my mistakes. Thank you.
Since you are doing the calculation. I am not sure why you want to transfer numerical type to text?
could you pls provide the pbix file?
ryan_mayu
I figured out where I was going wrong. I was comparing a numeric column(
'Order'[Document.orderDetails.totalMileage]) to text "12". Once I changed "12" to 12, everything worked. You mentions of numeric and text prompted me to review the query and then I was able to see my mistakes. Thank you.
you are welcome