Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
vnqt
Helper V
Helper V

Power Query : Comparing a column to 2 other columns in other table

‎08-31-2023 08:39 AM

Hello,

Please help with the following requirement: 

Table 1 :  Reference

CenterCT_BCT_B+1APP_BAPP_B+1
AP1B4235B4240B4321B4674
AP2B4236B4240B4321B4674
AP3B4236B4240B4333B4674
AP4B4236B4240B4323B4674
AP5B4236B4240B4321B4674
AP6B4236B4240B4321B4674
AP7B4236B4240B4321B4674
AP8B4236B4240B4321B4674
AP9B4236B4240B4321B4674
AP10B4236B4240B4321B4674
AP11B4236B4240B4321B4674
AP12B4236B4240B4321B4674
AP13B4236B4240B4321B4674
AP14B4236B4240B4321B4674
AP15B4236B4240B4321B4674
AP16B4236B4240B4321B4674
AP17B4236B4240B4321B4674
AP18B4236B4240B4321B4674
AP19B4236B4240B4321B4674
AP20B4236B4240B4321B4674

 

Table 2  Center

CenterVersion
AP1B4236
AP1B4236
AP3B4236
AP4B4236
AP5B4236
AP6B4236
AP7B4236
AP8B4236
AP9B4236
AP10B4236
AP11B4236
AP12B4236
AP13B4236
AP14B4236
AP15B4236
AP16B4236
AP17B4240
AP18B4240
AP19B4240
AP20B4240

 

Table 3 APP

CenterAppVersion
AP1APP1Dido 8.2-B-B4236
AP1APP2Dido 8.2-B-B4236
AP1APP3Dido 8.2-B-B4236
AP1APP4Dido 8.2-B-B4236
AP1APP5Dido 8.2-B-B4236
AP1APP6Dido 8.2-B-B4236
AP1APP7Dido 8.2-B-B4236
AP1APP8Dido 8.2-B-B4236
AP1APP9Dido 8.2-B-B4236
AP1APP10Dido 8.2-B-B4236
AP1APP11Dido 8.2-B-B4240
AP1APP12Dido 8.2-B-B4240
AP1APP13Dido 8.2-B-B4240
AP1APP14Dido 8.2-B-B4240
AP1APP15Dido 8.2-B-B4240
AP2APP16Dido 8.2-B-B4240
AP2APP17Dido 8.2-B-B4240
AP2APP18Dido 8.2-B-B4235
AP2APP19Dido 8.2-B-B4235
AP2APP20Dido 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 : 

vnqt_0-1693571777002.png

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 

 

vnqt_2-1693572009065.png

 

Thank you in advance for your help.

Tg

 

 

Labels:
Message 1 of 3
207 Views
0
2 REPLIES 2
parry2k
Super User
Super User

‎08-31-2023 09:51 AM

@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.

Message 2 of 3
187 Views
0
vnqt
Helper V
Helper V
In response to parry2k

‎09-01-2023 05:43 AM

Hi @parry2k 

Since you asked a good question, I've updated all the requirements. Thank you in advance for your help. 

Message 3 of 3
173 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

View All