Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hey Community,
You guys have been amazing support on my journey with Power BI till now. Special shoutout to @amitchandak for promptly solving these queries.
I have another question for you guys, Table1 has ID as primary key, table 2 has repeated value of ID and has a score attached to it, what i want to achieve is, i want to create a calculated column in table 1 that says "Rated" if ID appears in Table 2, and returns "Not-Rated" if iD doesn't appear in Table 2. I'm attaching a screenshot to make my question clearer. Also, the relationship between the two table is 1 to Many(Single), please advise if this needs changing as well.
Thanks for your responses in advance.
Solved! Go to Solution.
¿ @KrtinM
You can create a chalkualized column by using an IF and LOOKUPVALUE statement:
I hope this helps!
Follow
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
@Anonymous LOOKUPVALUE is a really great function! I am glad I could help my friend!
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
It works perfectly, thank you so much, you're a legend, had never used lookup function in PowerBI till now.
@Anonymous LOOKUPVALUE is a really great function! I am glad I could help my friend!
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
¿ @KrtinM
You can create a chalkualized column by using an IF and LOOKUPVALUE statement:
I hope this helps!
Follow
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |