POWER BI: Modeling

Divide Function

The divide function eliminates the risk for zero division error. The three arguments of the divide function are:

  • numerator
  • denominator
  • alternate result

For example to find ROI:

                         ROI = DIVIDE(
                                 SUM(TransactionData[Total Profit]),
                                 SUM(TransactionData[Cost (total)]),0)            
	                

Note: this must be made as a new Measure rather than a calculated column.





Services
  • SEO
  • Online Advertising
  • Online Ordering For Restaurants
  • Data Analytics

  • External Resources 4 Developers
  • CSS Tricks
  • MDN

  • Dash-Intel.com is a Power BI and Tableau resource site around data visualizations and building business dashboards.

    Data Analytics consultants in Edmonton, Alberta specializing in Tableau and marketing analytics

    Copyright 2020 Dash-Intel.com Terms / All rights reserved.