Forum Discussion
ak77
3 years agoPost Patron
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...
parry2k
3 years agoSuper User
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
3 years agoPost Patron
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