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
Dr_Chris
Helper I
Helper I

Newbie Question - struggling to refer to values in another table

Hi

I have two tables

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

TimestampProductQuantity
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
28ABC300
29ABC

380

30ABC410
28XYZ60
29XYZ130
30XYZ110

 

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

 

1 REPLY 1
amitchandak
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: https://youtu.be/so_A22HXbwM

 

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

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.