Forum Discussion

mahirk's avatar
mahirk
New Member
9 years ago

Percentage calculation in PowerPivot

Hi All,

 

I have a table in PowerPivot with Month, Quarter,Product and Actual for 3 years data. I need a calculating column or Measure which calculates percentage of Month. It needs to calculate as Sum of the Total Month/Sum of the Quarter.

Is it possible? Please help

 

Thanks & Regards,

Mahesh

Need Help

2 Replies

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi mahirk,

      I create the sample data table which including date and sales for each day. 

      I create calculated columns to get year, quarter and month.

      Year = YEAR(Test1[Date])

Quarter = ROUNDUP(MONTH(Test1[Date])/3, 0)

Month = MONTH(Test1[Date])


      Create a calculating column which calculates percentage of Sum of the Total Month VS Sum of the Quarter.

       

      Percentage = CALCULATE(SUM(Test1[Sale]),ALLEXCEPT(Test1,Test1[Month]))/CALCULATE(SUM(Test1[Sale]),ALLEXCEPT(Test1,Test1[Quarter]))





      Finally create a table to display the result.



      If you have other issues, please let me know.


      Best Regards,
      Angelia