Skip to main content
cancel
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

Reply
arjuns0028
Helper I
Helper I

Showing % Enrollment using Enrol_Count

arjuns0028_0-1712042848526.png

arjuns0028_1-1712043015430.png

 

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

2 REPLIES 2
Gabry
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

Announcements
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.

PBI_Carousel_NL_June

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