Dashboarding & Reporting With Power Bi : How to Design and Create a Financial Dashboard With Power Bi End to End (9781615473632) by De Jonge Kasper

Author:De Jonge, Kasper
Language: eng
Format: epub
Tags: Power BI;Business Intelligence;Microsoft;Power BI Desktop
Publisher: Independent Pub Group
Published: 2019-01-30T00:00:00+00:00

Data Model Tip: The DIVIDE Function

The DIVIDE function ensures that either BLANK or an actual value is returned and is optimized for performance. When you use the / operator, DAX has to handle the divide-by-zero error every time it happens, and this results in a performance hit. The DIVIDE function is short-circuited to just return BLANK or an error value that you can optionally enter in the arguments when a divide-by-zero error is encountered. It’s recommended to use the DIVIDE function whenever possible.

Because this is a percentage, Jim changes the format to percentage, and he adds the measure to the matrix.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.