Percentage calculation in PowerPivot

[mahirk]

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

[mahirk]

Can someone helpme out in the formula

[v-huizhn-msft]

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