Forum Discussion
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 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
7 Replies
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/38490In this case, I assumed QTD_MS_Change is a measure.
Thanks for the link. will check
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
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 😞
