Forum Discussion

renugiri's avatar
renugiri
New Member
9 years ago

desktop

Hi,

 

I have multiple tables with common columns, with the following details,

 

Table1: with columns--> Uid,UName,DOB

Table2: with columns-->UID,datecreated,Lastupdated


Now My case is,


 case1 :select Uid from Table1 where uid in (select uid from Table2);

 

case2: select Uid from Table1 where uid in (select uid from Table2);


What i DO need:

 

with the above results, i need a new MEASURE with the results of case1 as paired, with results of case2 as not paired

 

Can Anyone help me to create a NEW MEASURE

 

Regards,

Giri

Need Help

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi renugiri,

     

    Please elaborate your requirement with some examples. Please provide images which can better show your report design and expected output. It's hard to imagine what measure you want and what does "with the results of case1 as paired, with results of case2 as not paired" mean.

     

    Best regards,
    Yuliana Gu