March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
@vnqt 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.
Hi @parry2k
Since you asked a good question, I've updated all the requirements. Thank you in advance for your help.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
91 | |
90 | |
83 | |
73 | |
49 |
User | Count |
---|---|
167 | |
149 | |
98 | |
73 | |
57 |