Power Query : Comparing a column to 2 other column...

Anonymous · ‎08-31-2023

Hello,

Please help with the following requirement:

Table 1 : Reference

Center	CT_B	CT_B+1	APP_B	APP_B+1
AP1	B4235	B4240	B4321	B4674
AP2	B4236	B4240	B4321	B4674
AP3	B4236	B4240	B4333	B4674
AP4	B4236	B4240	B4323	B4674
AP5	B4236	B4240	B4321	B4674
AP6	B4236	B4240	B4321	B4674
AP7	B4236	B4240	B4321	B4674
AP8	B4236	B4240	B4321	B4674
AP9	B4236	B4240	B4321	B4674
AP10	B4236	B4240	B4321	B4674
AP11	B4236	B4240	B4321	B4674
AP12	B4236	B4240	B4321	B4674
AP13	B4236	B4240	B4321	B4674
AP14	B4236	B4240	B4321	B4674
AP15	B4236	B4240	B4321	B4674
AP16	B4236	B4240	B4321	B4674
AP17	B4236	B4240	B4321	B4674
AP18	B4236	B4240	B4321	B4674
AP19	B4236	B4240	B4321	B4674
AP20	B4236	B4240	B4321	B4674

Table 2 Center

Center	Version
AP1	B4236
AP1	B4236
AP3	B4236
AP4	B4236
AP5	B4236
AP6	B4236
AP7	B4236
AP8	B4236
AP9	B4236
AP10	B4236
AP11	B4236
AP12	B4236
AP13	B4236
AP14	B4236
AP15	B4236
AP16	B4236
AP17	B4240
AP18	B4240
AP19	B4240
AP20	B4240

Table 3 APP

Center	App	Version
AP1	APP1	Dido 8.2-B-B4236
AP1	APP2	Dido 8.2-B-B4236
AP1	APP3	Dido 8.2-B-B4236
AP1	APP4	Dido 8.2-B-B4236
AP1	APP5	Dido 8.2-B-B4236
AP1	APP6	Dido 8.2-B-B4236
AP1	APP7	Dido 8.2-B-B4236
AP1	APP8	Dido 8.2-B-B4236
AP1	APP9	Dido 8.2-B-B4236
AP1	APP10	Dido 8.2-B-B4236
AP1	APP11	Dido 8.2-B-B4240
AP1	APP12	Dido 8.2-B-B4240
AP1	APP13	Dido 8.2-B-B4240
AP1	APP14	Dido 8.2-B-B4240
AP1	APP15	Dido 8.2-B-B4240
AP2	APP16	Dido 8.2-B-B4240
AP2	APP17	Dido 8.2-B-B4240
AP2	APP18	Dido 8.2-B-B4235
AP2	APP19	Dido 8.2-B-B4235
AP2	APP20	Dido 8.2-B-B4235

I would like to add the column "Status" to Table 2 as below :

The same Center, if the version in table 2 = [ CT_B] or = [CT_B+1] in Table 1 ==> OK

Table 2 :

Table 3 :

In the same Center, IF The build part in the version ( In red) = 'Table1 Reference'[APP_B] or = 'Table1 Reference'[APP_B+1] ==> OK

Thank you in advance for your help.

Tg

parry2k · ‎08-31-2023

@Anonymous Does Center column value unique in both tables?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.