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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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]))

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Rogerh , if need a column.

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

Thank you @amitchandak 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.