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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.