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