Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello all
I have 2 tables, in one the production steps of a part and in second the rejected parts IDs.
I would like to add the reject reason code to the rejected table from the production table .
In the production table one ID appears with blank value (reject reason empty) until one item is rejected, than a reject reason code is added.
I used:
Solved! Go to Solution.
SO i was able to solve the issue. I assumed that the FIRSTNOBLANK finds the first no blank values between the filtered data, which seems to be incorrect.
I added another filter with && filtering the process step, there additional results appeared.
I added a third filter for a third row, reject qty = 1. with these I have correct results.
The final formula looks like:
Maybe there is a more elegant way to do this... long way to learn DAX
Thx
SO i was able to solve the issue. I assumed that the FIRSTNOBLANK finds the first no blank values between the filtered data, which seems to be incorrect.
I added another filter with && filtering the process step, there additional results appeared.
I added a third filter for a third row, reject qty = 1. with these I have correct results.
The final formula looks like:
Maybe there is a more elegant way to do this... long way to learn DAX
Thx
Hi @Tommyvhod ,
1.Based on this"In the production table one ID appears with blank value (reject reason empty) until one item is rejected, than a reject reason code is added."
Please just build a relationship between two tables:
2. I would like to add the reject reason code to the rejected table from the production table .
Please try this method to create a column:
Column = LOOKUPVALUE(Data[Rjct code],Data[ID],'Scrap'[ID])
Here is my PBIX file. Hope this helps you.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |