Forum Discussion
Transforming value
Hi all,
I want to create the column "NEW_VAL" in Power BI. Can you guys help me out? So if the number is greater than 5 I the value needs to do something like * 1. But I dont know how to that in Power BI
Anonymous Please try this..
NewVal = IF(Test132[Number]>5,Test132[Value]*-1,Test132[Value])
1 Reply
Anonymous Please try this..
NewVal = IF(Test132[Number]>5,Test132[Value]*-1,Test132[Value])