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
Gisela
Helper I
Helper I

Adding a column which calculates % of the two other columns

Sample_data_for_Power_BI_forum.png

Hi, I am new at PowerBI and could not find an answer to this probably easy question.

 

I have the table above

I want to add a column which show the % of "Ttl rcvd new"/"Total sent"

 

"Ttl rcvd new" & "Total sent" are  from different excel sheets

I have tried to add a measure to calculate the % but 1/ I don't know where to add the measure 2/ i get an error or it just showed 100% for both.

 

How can I add the % column?

 

Thank you,

Gisela

 

 

 

Sample_data_for_Power_BI_forum2.png

1 ACCEPTED SOLUTION
12 REPLIES 12

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.