DAX Divide Function - DAX for Power BI and Power Pivot
When you are working in Excel it is relatively easy to divide two numbers. You take the value from one cell, and divide it by the value or the in another cell. For Example =B3/B2. Divide is a basic mathematical operator. In Excel if you try to divide a value by zero you will get the error #DIV/0!
Power BI and Power Pivot don't work on cell references like Excel. They both work on columns of data. It is very common to add a calculated column using divide. A perfect example would be on a sales table to take the profit column and divide it by sales column to get the gross profit %.
Using the mathematical divide in Power BI or Power Pivot can lead to a problem if your table of data contains a 0. Instead of returning an error, you will be returned with the symbol for infinite ∞. It is also common not to spot this error. This is because when you are working with your data in Power BI or Power Pivot, only a subset of your data is visible. It is possible that zeros are further down your data set and you have not seen them.
So how can you overcome this problem in Power BI or Power Pivot? DAX is to the rescue the DIVIDE function. The syntax is =DIVIDE(Numerator, Denominator, [AlternateResult])
In this video 'DAX for Power BI and Power Pivot - DAX Divide Function' you will see how using the standard mathematical divide can yield ∞. You will also see how this can be avoided by using the DAX Divide function
In return for this tip DAX for Power BI and Power Pivot - DAX Divide Function, I ask that you share this post or the video with your friends and colleagues
Sign up for my newsletter – Don’t worry, I wont spam – Just useful Excel and Power BI tips and tricks to your inbox SIGN UP NOW
This blog is powered by the STEEM blockchain using Steempress.io as the integration tool. To comment on this post you must have a STEEM account. You can use this link to register for a STEEM account. We are a tokenized website where you can earn while you learn.
Cross posted from my blog with SteemPress : https://theexcelclub.com/dax-divide-function/
But the end of all things has drawn near. Therefore be sober-minded and be sober unto prayers.(1 Peter 4:7)
Question from the Bible, Is there such a thing as untimely death in the Bible?
Watch the Video below to know the Answer...
(Sorry for sending this comment. We are not looking for our self profit, our intentions is to preach the words of God in any means possible.)
Comment what you understand of our Youtube Video to receive our full votes. We have 30,000 #SteemPower. It's our little way to Thank you, our beloved friend.
Check our Discord Chat
Join our Official Community: https://steemit.com/created/hive-182074