Forum Discussion

abukapsoun's avatar
abukapsoun
Icon for Post Patron rankPost Patron
6 years ago
Solved

Multiplying values

Hi, Need your support please. I have the following Table   Reference P01 P02 X -1000 500 Y 800 -600                 How can i transform the sign of values based on ...
Need Help
  • darentengmfs's avatar
    darentengmfs
    6 years ago

    Hi abukapsoun 

     

    There are 2 ways to do this.

     

    1. You can unpivot the columns, then create the new column with the IF function in DAX
    2. Or, you can create the IF function in Power Query Editor before unpivoting: Power Query > Add Column > Custom Column > Formula: if [Reference] = "X" then [P01]*-1 else [P01]

     

     

    **Update: formula amended as needed

Seenu80's avatar
Seenu80
Regular Visitor
3 years ago

Hi Experts,

need your support on below i have absolute value in one column

Shkg  Value

H        100.00

S           50.00

 

if H, i need to do 100.00*-1 if S then 50.00. can you suggest how can i add new column based on above condition.

 

Regards

Srini