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.

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

  • External Resources 4 Developers
  • CSS Tricks
  • MDN

  • Dash-Intel is a Power BI and Tableau resource site for data visualization and building BI dashboards.

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

    Copyright 2021 Dash-Intel.com Terms / All rights reserved.
    Powered By The Order Guys