cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Transforming value

Hi all,

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

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

Regards,

Ozgur

2 ACCEPTED SOLUTIONS
Resolver V
`NEW_VAL = IF([Number] in {30000;90000};[Value]*(-1);[Value])`

try this

Resolver V

probably, not

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

3 REPLIES 3
Resolver V
`NEW_VAL = IF([Number] in {30000;90000};[Value]*(-1);[Value])`

try this

Anonymous
Not applicable

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

Regards,

Ozgur

Resolver V

probably, not

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.