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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## percent to goal

Hello,

I have some data that looks like this

table 1

job count     start week               queue

5                      5/1/2019              a

10                    5/8/2019              a

12                    5/1/2019              b

20                    5/8/2019              b

8                     5/1/2019               c

etc...

table 2

job count goal          queue

10                               a

10                               b

8                                 c

etc..

How do I calculate the % to goal by each queue?

1 ACCEPTED SOLUTION
Community Support

@Anonymous

You may use RELATED Function or LOOKUPVALUE Function to add a calculated column.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Super User

Hey,

unfortunately the required result is not fully clear, how do you calculate the % to goal kpi.

what is your expexted result for queue a on May 2019, on May 1st and May 8th?

Is queue a distinct in table 2, are both tables related.

Can you please provide these additonal insights?

Regards,

Tom

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Anonymous
Not applicable

These are the results I'm expecting just a week to week. Not overall for the month.

 50.00% 5/1 a 100.00% 5/8 a 120.00% 5/1 b 200.00% 5/8 b 100.00% 5/1 c

Yes, queue a,b,c etc are distinct and the tables are related. We actually have 5 distinct queues. Our employees work each of these queues and we need  to hit a certain percentage to goal each week.  Hope this helps. Thank you.

Community Support

@Anonymous

You may use RELATED Function or LOOKUPVALUE Function to add a calculated column.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

## Helpful resources

Announcements

#### Power BI Monthly Update - July 2024

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

#### Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors