Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |