Forum Discussion

3 Replies

  • rintu's avatar
    rintu
    Regular Visitor
    3 years ago

    Below is the sample output from the formula ( LOOKUP(SUM(max([Inclass],[Graduated])), -1). 

    AYearGroup levelNumberSizeRquired ResultGraduatedInclass
    2015-1- Spring2015F13105,306
    2015-1- Spring2015F235,30653,962
    2015-1- Spring2015F333,962773,296
    2015-1- Spring2015F433,3011852,763
    2015-1- Spring2015F532,8404172,406
    2015-1- Spring2015F632,5917691,970
    2015-1- Spring2015F732,3869981,598
    2015-1- Spring2015F832,3661,2111,300
    2015-1- Spring2015F932,2981,3551,052
    • DataVitalizer's avatar
      DataVitalizer
      Super User
      3 years ago

      Hi rintu 

      If you want to write that formula in DAX, try this code

       

      MeasureName = 
      VAR CurrentSum = SUMX(SUMMARIZE('Table', 'Table'[Item], "MaxValue", MAX('Table'[Inclass], 'Table'[Graduated])), [MaxValue]) 
      VAR PreviousSum = CALCULATE([CurrentSum], FILTER(ALL('Table'), 'Table'[Item] = EARLIER('Table'[Item])) - 1) 
      RETURN 
      DIVIDE([CurrentSum], PreviousSum)


      Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated