Forum Discussion

drrai66's avatar
drrai66
Icon for Resolver I rankResolver I
8 years ago
Solved

Need Help On Creating a Column from two linked Data sources

Hi Guys, I really Need Help Here to Convert This in Tableau to Power BI. Scenario is If I have two Tables In Tableau  Like:   Table1   Student  Marks A 80 B 90 C 100 D 50 ...
Need Help
  • Nishantjain's avatar
    Nishantjain
    8 years ago

    Create a calculated column in Table1 using the formula below

     

    if(calculate(countrows(table2),filter(table2,table2[Student]=table1[Student]))>0,1,0)

Nishantjain's avatar
Nishantjain
Icon for Continued Contributor rankContinued Contributor
8 years ago

Create a calculated column in Table1 using the formula below

 

if(calculate(countrows(table2),filter(table2,table2[Student]=table1[Student]))>0,1,0)