Forum Discussion

ak77's avatar
ak77
Post Patron
3 years ago

Sign change

Hi All,   i need a help.. i have the below table where i have a measure QTD_MS_Change doing a calculation. i need to change the sign (+ if -) and (- to +)  for all the rows which has Benchmark in A...
Need Help
Show and Tell
parry2k's avatar
parry2k
Super User
3 years ago

ak77 wrap it with IF condition:

 

New Measure = 
IF ( CONTAINSSTRING ( SELECTEDVALUE ( YourTable[YourColumn] ), "Benchmark" ), -1, 1 ) 
* [Your Measure]