Forum Discussion

sohailstsindia's avatar
sohailstsindia
Helper I
7 years ago

filtering data from same table with different column

ProjTransRefTransOrigTransAMOUNT
208428  6
295865208428 -6
2958662084282084286
295869  8

 

Any body help me to transform the data below.

 

ProjTransAmountRefTransProjTransAmountOrigTransProjTransAmount
2084286YES295865-6YES2958666
2958698No  No  
        
  if(ProjTrans in RefTrans) then YES else Noif(ProjTrans = RefTrans && OrigTrans ="Null") then ProjTransif(ProjTrans = RefTrans && OrigTrans ="Null") then Amountif(ProjTrans =  OrigTrans ) then "YES" Else Noif(ProjTrans =  OrigTrans ) then ProjTransif(ProjTrans =  OrigTrans ) then Amount
Need Help

2 Replies

  • 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