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 |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |