cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sirlanceohlott Regular Visitor
Regular Visitor

Split Percentage Against Multiple Values In One Column

Good morning,

 

I have a specific requirement for a project where JobOrders typically have a single office where they reside; however, as with any company there is an exception to the rule and some JobOrders have multiple offices (2,3,4).

 

If multiple offices are involved the Office Column has the following format: Minneapolis, Dallas, Denver

 

The end goal for the above example would be to give each office 33.33% for the JobOrder. 

 

I have a feeling I might end up having to work my way back into SQL on this one, but I thought I'd seek out what your thoughts are as a community.

 

Have a great Friday!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Split Percentage Against Multiple Values In One Column

It will make more sense to split job offices in power query and then it will be very easy to split the percentage.





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

2 REPLIES 2

Re: Split Percentage Against Multiple Values In One Column

It will make more sense to split job offices in power query and then it will be very easy to split the percentage.





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

sirlanceohlott Regular Visitor
Regular Visitor

Re: Split Percentage Against Multiple Values In One Column

@parry2k I agree, this seems to make the most sense as to how to approach this issue. 

 

Cheers!

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,915)