Forum Discussion

BeastHouse's avatar
BeastHouse
Frequent Visitor
3 years ago
Solved

IF/OR Formula Help

Hi, trying to calculate an exchange rate used in a procurement data set. The below formula is throwing the error DAX comparison operations do not support comparing values of type Number with values o...
blanks
if
OR
values
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi BeastHouse 

    try like:

    Exchange Rate =
    IF(
    'Stock Orders'[Exchange Rate For Report Estimates]=0,
    1,
    'Stock Orders'[Exchange Rate For Report Estimates]
    )
     
    DAX take 0 and blank as the same.
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi BeastHouse 

try like:

Exchange Rate =
IF(
'Stock Orders'[Exchange Rate For Report Estimates]=0,
1,
'Stock Orders'[Exchange Rate For Report Estimates]
)
 
DAX take 0 and blank as the same.
BeastHouse's avatar
BeastHouse
Frequent Visitor
3 years ago

I think this could be the simple way of going about it! I am trying to transfer from Excel to Power Bi, so struggle with translating some of the formulas in the existing database. Thanks a lot.