Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
bozdemir
Frequent Visitor

Calculation (or Measures) for rows

Hello,

I have a table such as the following abd want to add the % row (last row), which is based on the two rows from the table.  Is there a way to do this?  Thanks very much.

Accounts Receivables AgingMonth 1Month 2Month 3
0-30 Day$7.0$11.0$12.0
31-60 Day$8.0$12.0$10.0
60+ Days$5.0$3.0$6.0
Current$30.0$34.0$12.0
Total Open Amount$50.0$60.0$40.0
    
60+Days past due as a % of total amount10.0%5.0%15.0%
1 ACCEPTED SOLUTION

Thanks, Stachu.  It worked. I did not have to follow all the steps you described.  But now, I have a measure that calculates the % I want.  Thanks again.

View solution in original post

2 REPLIES 2
Stachu
Community Champion
Community Champion

have a read here
https://community.powerbi.com/t5/Desktop/Create-calculated-row/td-p/440613



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Thanks, Stachu.  It worked. I did not have to follow all the steps you described.  But now, I have a measure that calculates the % I want.  Thanks again.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.