Forum Discussion

Impactful 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
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

Super User

6 years ago

Hi vjnvinod ,

You can use the below Measure for your new requirement.

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

I expect Kudos to my previous answer 😊 and this answer as well. And Please Accept this as a solution.