Power bi DIFFERENCE BETWEEN YEARS BUT HOW TO REMOVE -VE SIGN FROM AMOUNT. I NEED SIGN IN THE DIFFERENCE COLUMN

Question

![78077-capture.jpg][1] [1]: /api/attachments/78077-capture.jpg?platform=QnA in the attached snippet, i am subtracting values y2y. Measure 2 = var Minaa = calculate (MIN('1500000 Sales Records'[Year]), ALLSELECTED('1500000 Sales Records'[Year])) var Maxaa = calculate (MAX('1500000 Sales Records'[Year]), ALLSELECTED('1500000 Sales Records'[Year])) var result = calculate ( sum('1500000 Sales Records'[Total Cost]), year('1500000 Sales Records'[Order Date])= Maxaa)- calculate ( sum('1500000 Sales Records'[Total Cost]), year('1500000 Sales Records'[Order Date])=Minaa ) return result problem is how to remove negatve sign from 2014 column. one more problem, how to calculate difference sales amount between month in a year.

Answer 1

Hi Nitin,

Power BI related questions are not supported on this forum. It's better to reach out experts in dedicated forum over here:

https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav