Need to add - or + sign to result

[Anonymous]

Hello Community,

How can I add – or + sign to below Result 2013 ?

Divide = DIVIDE('Table'[2014],'Table'[2013])/100

Row Data
Product	2013	2014	2015
A	263,054	269,324	242,002
B	258,953	250,947	245,165
C	312,204	296,797	286,313
D	304,018	277,953	286,522

Power Bi Result		Excel Result
Product	Result 2013		Product	2013
A	1.02%		A	2%
B	0.97%		B	-3%
C	0.95%		C	-5%
D	0.91%		D	-9%

[amitchandak · Accepted solution]

To me, it seems like a calculation issue

formula should be DIVIDE('Table'[2014]-'Table'[2013],'Table'[2013])/100

or

(DIVIDE('Table'[2014],'Table'[2013])/100) -1 .

Then go to field formatting and change no of the decimal place.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

Hi Amit,

Thank you so much it is working perfectly fine...below forumual generate the correct result.

DIVIDE('Table'[2014]-'Table'[2013],'Table'[2013])/100

Thanks