Forum Discussion

databot_kd's avatar
databot_kd
Icon for Helper III rankHelper III
3 years ago
Solved

DAX Calculation - previous rows value bought into current row

Hi community,    How can i bring the previous rows value into the current row?   HC Latest Mon/Yr measure: CALCULATE(COUNT('Headcount Details'[Position]),                     MAXX(   ...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    you forgot the bracket for ALLSELECTED('Headcount Details)

    -----------------

    Measure=
    CALCULATE(
    [HC Latest Mon/Yr],
    OFFSET(-1,SUMMARIZE(ALLSELECTED('Headcount Details),'Headcount Details'[YearD]),ORDERBY('Headcount Details'[YearD]))
    )

     

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

pls try this

 

 

 

 

Measure= 
CALCULATE(
[HC Latest Mon/Yr], 
   OFFSET(-1,SUMMARIZE(ALLSELECTED('Headcount Details),'Headcount Details'[YearD],'Headcount Details'[MaxCurrentMonthYear]),ORDERBY('Headcount Details'[YearD]))
)

 

 

 

 

  • databot_kd's avatar
    databot_kd
    Icon for Helper III rankHelper III
    3 years ago

    Thanks Ahmedx for responding. 

    MaxCurrentMonthYear is also a measure 

    MAXX(
                        KEEPFILTERS(VALUES('Headcount Details'[YearD])),
                        CALCULATE(MAX('Headcount Details'[Month]))
                    )
     
    it wont seem to work with SUMMARIZE



    • Ahmedx's avatar
      Ahmedx
      Icon for Super User rankSuper User
      3 years ago

      try this

      Measure= 
CALCULATE(
[HC Latest Mon/Yr], 
   OFFSET(-1,SUMMARIZE(ALLSELECTED('Headcount Details),'Headcount Details'[YearD]),ORDERBY('Headcount Details'[YearD]))
)
      • databot_kd's avatar
        databot_kd
        Icon for Helper III rankHelper III
        3 years ago

        Unfortunately, still no luck. 

        Below is the error 


        YearD is a calculated column:
        YearD = YEAR(date column)