Sign change

[ak77]

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 Asset/SubClass benchmark Columns

For Ex: 1.48 to -1.48 , 3.44 to -3.44, -4.54 to 4.54 and so on.  is there a way to achive this. Please help

[parry2k]

@ak77 when you do ask for a question, please follow some guidelines, just sharing the screenshot and asking the question doesn't help. Please spend five minutes and read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

In this case, I assumed QTD_MS_Change is a measure.

[ak77]

@parry2k , Please find the sample PBIX. i want to achieve the difference between previous 2 rows and display in the 3rd row. currently it is giving the sum. is it possible to get the difference For Ex: 4.37-2.95=1.42 and so on. Thanks again for the help

https://drive.google.com/file/d/1wT79uscBn5IBLd1nrbYi9vulHgzYBx_D/view?usp=sharing

[ak77]

Thanks for the link. will check

[ak77]

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

@parry2k , Thanks .  My question is how can i use [Your Measure] in [New measure] in the above expression..

when i try creating [New measure] and try to access [Your Measure] to use it in the formula.. it does not show up 😞

[parry2k]

@ak77 wrap it with IF condition:

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

[ak77]

@parry2k , Thanks for reply...tried that..but it is changing sign for all the values. i need it only for rows which has benchmark. if i try to use a new measure to put a condition.. i am not able to use measure within measure

[parry2k]

@ak77 multiply it with -1 ([Measure] * -1)