I'm currently facing a problem with merging to tables together
In one table I have the SKU running on the line and in the other table I have the description of the problem that happened on the line.
I want to identify on which SKU I had a bad material issue
Knowing that I'm having a problem with merging the two tables because in table 2, I have the same date for the same line , for the same shift but for different issues.
Can anyone help with that?
Please check if this makes sense.
I have added a helper column in both the tables by merging Day, Line & Shift.
Then established a relationship between 2 tables using the helper columns.
Using the below dax formula, Created a calculated column the table where you have the Problem description to match & pull the associated SKU ID's from table 1.
SKU = LOOKUPVALUE(SKUTable[SKU],SKUTable[Merged],PrbDescription[Merged])
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.