Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Newbie Question - struggling to refer to values in another table


I have two tables

Table 1 - Production
Contains record of products booked into the warehouse

20/07/2021 13:45ABC2
20/07/2021 14:12XYZ32
20/07/2021 16:38ABC54

Table 2 - Weekly Targets
Simply contains the target production per week

Week NumberProductTarget




I'm trying to display a series of guages - one for each product and for each day of the week, showing the numbers produced each day against the daily target based on the weekly target / 5  (So in week 28 we need to make 60 units of ABC each day to meet out target)

I've manage to create the guages for each day of the week and each product from the 'Production' table
I've also got the filters working so that I only use the production quantities for this week in each guage
I can also
- add a column to the 'Weekly Targets' table that contains the [Daily Target]
- add a colum to the 'Production' Table that contains the Week Number for that entry

but now I can't fathom out how to use the new 'Weekly Target'[Daily Target] values to set the target in the guage

I feel a bit dim...




Super User
Super User

@Dr_Chris , Based on what I got, One way is split weekly target to daily in the table, Using a date table and week year, you can join both on year week and divide target by 5 or 7. if needed you can make weekend target as 0


Create a date table in power query, with weekday and year and then merge and create new custom column

Date Table in Power Query:

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors