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

Nitin Kumar Vashisht 21 Reputation points
2021-03-16T07:16:00.597+00:00

![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.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,541 questions
0 comments No comments
{count} votes

0 additional answers

Sort by: Most helpful