Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago
Solved

change number to abs value using a filter condition

Hi,   Can you help me with a measure, basically i need to convert any negative numbers in my coloumn(ActualChrdHours) to positive number if my coloumn(ReverseVsMercurry) is "Not a reverse".   ca...
Need Help
Show and Tell
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    HI vjnvinod ,

     

    Your Switch column has created in different table than where yours Reverse and ActualChrdHours fields are coming. I suggest you to Right click on your DataDumpFull(2) Table at right side of Pane then click on create a New COlumn option.

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

Hi vjnvinod ,

 

Create 2 measures one for Reverse and another for Not a Reverse.

1. Reverse Charge=if(sum('Table'[ActualChrdHour])>0,(ABS(CALCULATE(SUM('Table'[ActualChrdHour])*-1,'Table'[ReverseVsMercurry]="Reverse Charge"))),sum('Table'[ActualChrdHour]))

 

2.  Not a Reverse = if(sum('Table'[ActualChrdHour])<0,(ABS(CALCULATE(SUM('Table'[ActualChrdHour]),'Table'[ReverseVsMercurry]="Not a reverse"))),sum('Table'[ActualChrdHour]))

 

Then use them into Switch statement like below by using third custom column:

Final Output Column=SWITCH('Table'[ReverseVsMercurry],"Not a reverse",[Not a Reverse],"Reverse Charge",[Reverse Charge])

 

Please Give KUDOS to this effort and accept this as a solution if it helps you!

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago

Tahreem24 

 

still doesn't helps

 

Switch function doesn't reads my table coloumn, see below, hence the Switch logic doesn't works

 

 

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    HI vjnvinod ,

     

    Your Switch column has created in different table than where yours Reverse and ActualChrdHours fields are coming. I suggest you to Right click on your DataDumpFull(2) Table at right side of Pane then click on create a New COlumn option.

  • vjnvinod's avatar
    vjnvinod
    Icon for Impactful Individual rankImpactful Individual
    6 years ago

    Tahreem24 

    Super worked Like a charm

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    Hi vjnvinod ,

     

    WOW!!! Finally,  am really very happy that I helped you to solve this problem! ğŸ˜Š

    Good Luck!