Forum Discussion
Divide function with inifity result issue
Hi guys, I have been facing the Infinity issue when I have to divide by 0. This is the scenario, I have two columns one Original Qty and another one Updated Qty. I need to divide these two column...
Hi Anonymous
To solve this issue with pq you can use an if statement like :Dax dive function knows to deal with zeroes automatically
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.What is the error message?
Try this formula on my sample and share the link to the pbix...
What is the error message?
Try this formula on my sample and share the link to the pbix...
Found the reason, I had the IF capitalize. Thats a dumb error
Thank you