Forum Discussion

Courtb86's avatar
Courtb86
Frequent Visitor
2 years ago

Change iferror to percentage

In excel, I have a formula that is =1-(2/12) as an example. In Power BI key measures I have this formula set to an iferror statement due to an issue if some of my data has 0 as the value. 


The dax code is now IFERROR([Numerator]/[denominator], 0)

 

However, it is now not showing as a correct %. For example the excel formula is showing as 83.33% and the dax formula is now 16.67% and for the life of me, I cannot figure out how to subtract 100 from the 16.67% to make 83.33%. Any help would be greatly appreciated! 

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    No need for IFERROR.

     

    use DIVIDE([Numerator],[Denominator], 0)