cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rogerh
Helper II
Helper II

Custom Column to work out the Percentage of another column

Hello,

 

Can I please have some help on a custom column? I have read posts simular to mine but I am unable to get it to work.

 

I have a table for days of the week, (Mon to Sun), I used a custom column to count the total amount of orders per weekday from another table. I would like the next column to show what percentage of orders we get on what day of the week but I am unable to work out how to do it.

 

This is my current table, the last column is what I would like it to show. Can I please have some assistance with the code?

 

Week DayIndexOrdersPercentage of orders over a week
Mon1604216.83%
Tue2585716.32%
Wed3539815.04%
Thu4533214.86%
Fri5527214.69%
Sat6382710.66%
Sun7416211.60%

 

I need the data in a table to be able to use it the way I want to later.

 

Thank you in advance for any assistance.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Rogerh , if need a column.

new column = divide([Orders], sum([Orders]))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Rogerh , if need a column.

new column = divide([Orders], sum([Orders]))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Thank you @amitchandak 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!