Forum Discussion

drrai66's avatar
drrai66
Resolver 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)

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi drrai66,

 

To achieve your requirement, you can try this:

 

1. Create a relationship between Source1 and Souce2.

2. Create a measure like:

 

Result =
IF ( ISBLANK ( CALCULATE ( MAX ( Source2[Age] ) ) ), 0, 1 )

 

Thanks,
Xi Jin.

drrai66's avatar
drrai66
Resolver I
8 years ago

Yours Solution Looks pretty good, but the first formula gave me what I needed in my Actual Data set. Thanks for your Time !!!

Deepak