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.
Hello,
I have a rather simple calculation to be made, but I'm not able to do it:(
I have a table that contains two columns - ERP and Amount. I need tro create new column with Amount2 where Scala Amounts should be multiplied by 1000, the rest stays the same..
Could you please help?
Thnak you!
Solved! Go to Solution.
Hi @KatkaS
Can you try using an IF statement:
Amount2 = IF(ERP = "Scala", Amount * 1000, Amount)
@KatkaS ,
Create a new column
if([ERP] ="Scala",[Amount]*1000,[Amount])
@KatkaS ,
Create a new column
if([ERP] ="Scala",[Amount]*1000,[Amount])
Thank you very much, Amit, as always!
Hi @KatkaS
Can you try using an IF statement:
Amount2 = IF(ERP = "Scala", Amount * 1000, Amount)
Thank you!!
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |