Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@Anonymous Please try this..
NewVal = IF(Test132[Number]>5,Test132[Value]*-1,Test132[Value])
Proud to be a PBI Community Champion
@Anonymous Please try this..
NewVal = IF(Test132[Number]>5,Test132[Value]*-1,Test132[Value])
Proud to be a PBI Community Champion
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |