Showing % Enrollment using Enrol_Count

[arjuns0028]

How to get the % growth Enrollment if I have Enrol_Count column in Power BI?

[Gabry]

Hello arjuns0028 ,

not sure what  you mean.

To calculate the % growth the measure you should use is this:

Measure = (newvalue - oldvalue ) / oldvalue

then you format this as a percentage

so to put more in your data / tables could look like this:

% growth=
divide(Enrol_Count  - calculate (Enrol_Count , SAMEPERIODLASTYEAR(dates)),calculate (Enrol_Count , SAMEPERIODLASTYEAR(dates)))

let me know if this solve your issue

[arjuns0028]

Hi Gary,

I was able to the Enrolment and Amount but I was unable to get the percentage values. My values of the Enrollment were being displayed correctly but I was getting 0 % in both.
The columns are BC_Amount and Enrol_Count