Forum Discussion

databot_kd's avatar
databot_kd
Helper 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(
                    KEEPFILTERS(VALUES('Headcount Details'[YearD])),
                    CALCULATE(MAX('Headcount Details'[Month]))
                ) = 'Headcount Details'[Month])

Used to get the count of position for the max month month in the year. 
 
 
Thanks in advance
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 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]))
    )

     

6 Replies

  • Ahmedx's avatar
    Ahmedx
    Super 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
      Helper 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
        Super 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]))
)