Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
HI, i have a formula who works like this:
Solved! Go to Solution.
Use the DIVIDE function, it accounts for a divide by zero error
Hi @marcos_osorio,
You can use an IF statement.
TH Total Unit Margin = IF ( SUM ( 'BI Analysis'[Qtty] ) = 0, BLANK (), CALCULATE ( SUM ( 'BI Analysis'[Amount] ) / SUM ( 'BI Analysis'[Qtty] ), YEAR ( 'BI Analysis'[DATE RECORD] ) > 2017, 'Type of Data'[TYPE] = "Result" ) )
Best regards,
Yuliana Gu
Use the DIVIDE function, it accounts for a divide by zero error
Thank you very much!
I have a lot to learn of Power BI.
Thanks Again!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.