Forum Discussion

I-Jay-I's avatar
I-Jay-I
Frequent Visitor
7 years ago
Solved

Percentage Change Query

Hi All,   Im trying to calculate a percentage based off two other columns in my Power BI report. I have created a column called the Recovery Percentage to divide the Standard Rated Net by the Net. ...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    Hi I-Jay-I ,

     

    I suggest you to create a measure of Recovery Percentage, then it will work. The following is my sample you can have a try.

     

    The calculated column of Standard Rated Net and Reporting Month are both used your formula.

    Standard Rated Net = IF('Sheet1'[Rate]="SR",'Sheet1'[Net],0)
Reporting Month = EOMONTH(Sheet1[Date],0)

     

    Create a measure.

    Recovery Percentage = DIVIDE(SUM(Sheet1[Standard Rated Net]),SUM(Sheet1[Net]))

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-xuding-msft's avatar
v-xuding-msft
Community Support
7 years ago

Hi I-Jay-I ,

 

I suggest you to create a measure of Recovery Percentage, then it will work. The following is my sample you can have a try.

 

The calculated column of Standard Rated Net and Reporting Month are both used your formula.

Standard Rated Net = IF('Sheet1'[Rate]="SR",'Sheet1'[Net],0)
Reporting Month = EOMONTH(Sheet1[Date],0)

 

Create a measure.

Recovery Percentage = DIVIDE(SUM(Sheet1[Standard Rated Net]),SUM(Sheet1[Net]))

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

I-Jay-I's avatar
I-Jay-I
Frequent Visitor
7 years ago

Hi Xue Ding,

 

Thanks for this! It appears I was using new column instead of new measure.

 

Thanks!

 

Jay