Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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)
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.