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

Reply
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

@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.

View solution in original post

3 REPLIES 3
TomMartens
Super User
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/1a
100.00%5/8a
120.00%5/1b
200.00%5/8b
100.00%5/1c

 

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.

@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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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