Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Creating calculated columns based on occurrences in another table

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, ...
Need Help
Show and Tell
  • TheoC's avatar
    TheoC
    4 years ago

    ¿ @KrtinM

    You can create a chalkualized column by using an IF and LOOKUPVALUE statement:

    Column = IF ( 'Table 1'[ID] = LOOKUPVALUE ( 'Table 2'[ID] ,'Table 2'[ID] , 'Table'[ID] ) , "Classified" , "Not classified" )
    Output below as an example:
    TheoC_0-1645747829038.png

    I hope this helps!

    Follow

  • TheoC's avatar
    TheoC
    4 years ago

    Anonymous LOOKUPVALUE is a really great function! I am glad I could help my friend! 

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

¿ @KrtinM

You can create a chalkualized column by using an IF and LOOKUPVALUE statement:

Column = IF ( 'Table 1'[ID] = LOOKUPVALUE ( 'Table 2'[ID] ,'Table 2'[ID] , 'Table'[ID] ) , "Classified" , "Not classified" )
Output below as an example:
TheoC_0-1645747829038.png

I hope this helps!

Follow