Forum Discussion

sohailstsindia's avatar
sohailstsindia
Helper I
7 years ago

filtering data from same table with different column

ProjTrans RefTrans OrigTrans AMOUNT 208428     6 295865 208428   -6 295866 208428 208428 6 295869     8   Any body help me to transform the data below.   ProjT...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi sohailstsindia ,

 

Actually I cannot understand your logic here totally. Coul you please share more details about that?

 

Here I create two calculated columns to work part of that.

 

RefTrans1 = IF(Table1[ProjTrans] in VALUES(Table1[RefTrans]),"Yes","No")
origtrans1 = IF(Table1[ProjTrans] in VALUES(Table1[OrigTrans]),"Yes","No")

 

Also please find the pbix as attached.

 

Regards,

Frank

  • sohailstsindia's avatar
    sohailstsindia
    Helper I
    7 years ago

    hi Frank,

     

    Thank your your effort,

    I need ProjTrans, AMount then

    if ProjTrans no is in RefTrans and OrigTrans is Null then "YES" else "No" and Amount.

    and if ProjTrans is in OrigTrans then "YES" else "No" and Amount.

     

    All in one Row.

     

    regards,

    Sohail