Forum Discussion

zawlh's avatar
zawlh
Icon for Helper I rankHelper I
6 years ago
Solved

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. LINK is here https://docs.google.com/spreadsheets/d/1jIHEFFkpcD6pGQ3cvag0KSB3fqNMZPSZasTHZE2cJWU/ed...
  • az38's avatar
    az38
    6 years ago

    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)
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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)
zawlh's avatar
zawlh
Icon for Helper I rankHelper I
6 years ago

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