Newbie Question - struggling to refer to values in another table

[Dr_Chris]

Hi

I have two tables

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

Timestamp	Product	Quantity
20/07/2021 13:45	ABC	2
20/07/2021 14:12	XYZ	32
20/07/2021 16:38	ABC	54

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

Week Number	Product	Target
28	ABC	300
29	ABC	380
30	ABC	410
28	XYZ	60
29	XYZ	130
30	XYZ	110

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

Thanks

Chris

[amitchandak]

@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: https://youtu.be/so_A22HXbwM

https://radacad.com/append-vs-merge-in-power-bi-and-power-query