filtering data from same table with different column

[sohailstsindia]

ProjTrans	RefTrans	OrigTrans	AMOUNT
208428			6
295865	208428		-6
295866	208428	208428	6
295869			8

Any body help me to transform the data below.

ProjTrans	Amount	RefTrans	ProjTrans	Amount	OrigTrans	ProjTrans	Amount
208428	6	YES	295865	-6	YES	295866	6
295869	8	No			No
		if(ProjTrans in RefTrans) then YES else No	if(ProjTrans = RefTrans && OrigTrans ="Null") then ProjTrans	if(ProjTrans = RefTrans && OrigTrans ="Null") then Amount	if(ProjTrans =  OrigTrans ) then "YES" Else No	if(ProjTrans =  OrigTrans ) then ProjTrans	if(ProjTrans =  OrigTrans ) then Amount

[v-frfei-msft]

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]

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