cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ozgurozturkkk Frequent Visitor
Frequent Visitor

Transforming value

Hi all,

 

I want to create an extra column like this below (NEW_VAL). Can you guys help me out?
pbi3.PNG

 

 

 

 

 

 

 

 

 

 

 

So where the number is "30000" or "90000" the value needs to transform to a negative value.

 

Regards,

Ozgur 

2 ACCEPTED SOLUTIONS

Accepted Solutions

Re: Transforming value

NEW_VAL = IF([Number] in {30000;90000};[Value]*(-1);[Value])

try this

Re: Transforming value

probably, not

but u can add column [Number] in your table  from other table with LOOKUPVALUE

 

3 REPLIES 3

Re: Transforming value

NEW_VAL = IF([Number] in {30000;90000};[Value]*(-1);[Value])

try this

ozgurozturkkk Frequent Visitor
Frequent Visitor

Re: Transforming value

Hi @petrovnikitamai

 

Additional, the the numbers are in another table (Table X) and the values are in another table (Table Y). Will that work?

 

Regards,

 

Ozgur

Re: Transforming value

probably, not

but u can add column [Number] in your table  from other table with LOOKUPVALUE