Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
No need for IFERROR.
use DIVIDE([Numerator],[Denominator], 0)