cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Calculating Percent Change Without Date/Time

Hey everyone,
Please help me with one issue. I would like to know the percent change of my sheet.

I would like to use Course Name in X-AXIS and Count of User ID in Y-AXIS.

What I want in my report is to show percent change from Course1 to Course2, Course2 to Course3,Course3 to Course4,etc,...

When I search on google, all percent change formula include Date or Time. I saw Tableau can do percent change with built-in function. I hope one of specialist here can teach me how to do it in power BI.
With Thanks,
Power BI Newbie

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II

## Re: Calculating Percent Change Without Date/Time

Hi @zawlh

try a measure like

``````Measure =
var _curCourseCount = CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Course Name]))
var _prevCourse = CALCULATE(MAX('Table'[Course Name]),FILTER(ALL('Table'),'Table'[Course Name]< SELECTEDVALUE('Table'[Course Name])))
var _prevCourseCount = CALCULATE(COUNTROWS('Table'),ALL('Table'),'Table'[Course Name]=_prevCourse)
return
IF(_prevCourseCount=0,BLANK(),DIVIDE(_curCourseCount,_prevCourseCount)-1)``````

do not hesitate to give a kudo to useful posts and mark solutions as solution

2 REPLIES 2
Super User II

## Re: Calculating Percent Change Without Date/Time

Hi @zawlh

try a measure like

``````Measure =
var _curCourseCount = CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Course Name]))
var _prevCourse = CALCULATE(MAX('Table'[Course Name]),FILTER(ALL('Table'),'Table'[Course Name]< SELECTEDVALUE('Table'[Course Name])))
var _prevCourseCount = CALCULATE(COUNTROWS('Table'),ALL('Table'),'Table'[Course Name]=_prevCourse)
return
IF(_prevCourseCount=0,BLANK(),DIVIDE(_curCourseCount,_prevCourseCount)-1)``````

do not hesitate to give a kudo to useful posts and mark solutions as solution

Frequent Visitor

## Re: Calculating Percent Change Without Date/Time

Thank @az38
You are the real MVP.
You help me again.

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors