question

NitinKumarVashisht-1122 avatar image
0 Votes"
NitinKumarVashisht-1122 asked ·

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

![78077-capture.jpg][1] [1]: /answers/storage/attachments/78077-capture.jpg 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.

power-query-desktop
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered ·

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

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.