Forum Discussion

amulyasai's avatar
amulyasai
New Member
8 years ago

Monthly Percentage Formula not working

Hello, I am using the below formula to calculate monthly percentage change for the chosen month and the previous month. Reach % Chg. = (format((sum(fbAdData[Reach])-[Reach Prev. Month])/[Reach Prev...
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi amulyasai,

You need to share the formula of measure [Reach Prev. Month] and your .pbix to troubleshoot.

Best Regards,
Angelia

amulyasai's avatar
amulyasai
New Member
8 years ago

Hello Angelia,

The formula I'm using is 

Reach % Chg. = (format((sum('test data'[Reach])-'test data'[Reach Prev Month])/'test data'[Reach Prev Month],"+0%;-0%;0%"))

 

Power BI file and excel file is in the below wetransfer link

https://we.tl/8OxAMyE8Ut

 

Please let me know if you need anything else.

 

Looking forward to your response.

 

Thanks,
Amulya