Forum Discussion
jeevan_mehra
9 years agoRegular Visitor
Percentage calculation
Hi, I have half hourly intervalwise raw data available on which when I use pivot in excel and get #DIV error, I replace those with '0' which make my pivot look presentable. However, when I use th...
jeevan_mehra
9 years agoRegular Visitor
Hi,
I have a table with complete month data and it has some columns like total calls offered, answered, abandoned etc. Now, if I am trying to add a column like aban% where I am dividing abandoned by offered and trying to reflect it in my chart I am not getting the result which I am expecting, like it is giving me infinity error for some dates under the aban% column. Now, my main concern is how do I get rid of it. I know I can do this in excel but not sure how to do it in power bi. So, I am really looking for some help here...