Forum Discussion
Check if Value Exists in another column.
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.
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
6 Replies
- vivran22
Community Champion
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- vivran22
Community Champion
Can you share your model schema?
Cheers!
Vivek
Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter