Check if Value Exists in another column.

[oappdev]

Happy Sunday everyone,

Getting started with Power BI and need some guidance and the best approach. 

So i have 3 tables.

Table 1 - Hold the User Info with the questions.

Table 2 - Hold the the Value selected from the questions answer

Table 3 - Hold the Document Information/Type

Trying to figure out, when "Yes" is selected for "RecoveredFromCovid19AfterJune2020" to show in Column "SupportingDocument"

• Yes    (If there is a file attached) for that user.
• NULL (No file was attached)

Thank you so much in advance. Please, let me know if anything is unclear.

[vivran22]

Hey @oappdev ,

I understand that the COVID19User and Audit are related by Id. How you are relating the Document table with other tables?

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

[oappdev]

Thank you @vivran22 for the quick response.

On the Document table,  i have a column call "CreatedBy" and "LastModifiedBy" that capture the user Login ID that upload the document. Let me know if that answer your question.

[vivran22]

@oappdev 

Can you share your model schema?

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

[oappdev]

Happy Wednesday, @vivran22 Sorry for the delay.

Here is an updated Information. I was not able to grab the model schema, sorry about that. Let me know, if this works.

Thank you again for all your help. Let me know if you need any additional information.

[vivran22 · Accepted solution]

@oappdev 

Thanks for sharing details. Based on  your description, following is the sample I have created:

Data tables:

Model Schema:

Result:

Sample pbix file enclosed.

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

[oappdev]

Absolutely, Crazy Monday 😳 Give me a few @vivran22  Thank you again.