Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
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
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |