Forum Discussion

jeevan_mehra's avatar
jeevan_mehra
Regular Visitor
9 years ago

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...
Need Help
  • jeevan_mehra's avatar
    jeevan_mehra
    Regular Visitor
    9 years ago

    Thanks sean for your help. But, still not able to get the perfect result. Actually, I am calculating SL%, Aban% and Ans% based on the raw data. However, the result varies big time in power bi as compared to excel. For eg. SL% for 1st day of the month in excel comes to 89.3% and comes as 97.44% in power bi. Not sure, what to do next??

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi jeevan_mehra,

       

      Can you please share some detail content of your issue? It is hard to reproduce your issue from your description.

       

      Regards,

      Xiaoxin Sheng

      • jeevan_mehra's avatar
        jeevan_mehra
        Regular Visitor
        9 years ago

        Hi,

         

        I am not sure how to attach my data here. Can you guide me on that?