Forum Discussion

powerbi_bi's avatar
powerbi_bi
Frequent Visitor
9 years ago

TRUE/FALSE from another table

Hi, I have two tables in tabular model Table1 has multiple records with details Table 2 has distinct records with Status column (TRUE/FALSE)   How should I bring in this column to Table1   I t...
Sean's avatar
Sean
Community Champion
9 years ago

What formula do you use?

 

  • powerbi_bi's avatar
    powerbi_bi
    Frequent Visitor
    9 years ago

    I used the same formula, but I see blanks for records which are duplicates

    • Sean's avatar
      Sean
      Community Champion
      9 years ago

      Okay so how are the two tables related? Are you saying you are getting only one Status per Student_No in Table 1?

       

      • powerbi_bi's avatar
        powerbi_bi
        Frequent Visitor
        9 years ago

        Hi Sean,

        Firstly, thank you for the quick responses

         

        I'm sorry, the problem is with my data

        I investigated it and found out that Table2 doesnt have all the records as Table1 and hence the BLANKS in Table1

         

        Thanks Sean