Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I
Helper I

Showing % Enrollment using Enrol_Count




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

Responsive Resident
Responsive Resident

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

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

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors