Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Compare Staff Counts in Years

Hello,   I have a staff Count in Months from April 2021 - Aug 2023. I also have another staff Count for April 2023 - Aug 2025. The data looks as below   Im trying to do a table which compare...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous - you should consider using the PARALLELPERIOD dax function to change the filter context.  This allows you to specify a number of intervals.  This would include 2 YEAR.  The function would look something like this:

Function Name = CALCULATE ( [Count of Employees] , PARALLELPERIOD ( 'Date'[Date] , 2 , YEAR ) )

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Anonymous ,

     

    So this is the dax for how I get i get my staff count from April 2021-Aug 2023

    This gives me a table like this

    When I enter the Dax to shift 2 years:

    This is the Outcome 

     

    Sorry Im new to power BI and Im probebly doing somthing wrong

     
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Anonymous ,  my suggestion to use the Parallelperiod would result in two measures.  Current Month and Comparative Month, but I did not realise that you how your "pre suspension staff count" was working.

      Instead of using the Parallelperiod, you will need to modified the "selectedDate" variable to shift it by 2 years.  Consider the following examples:

       

      DateCurrent = MIN( 'Calendar'[Date] )
      DataAdd = CALCULATE( MIN( 'Calendar'[Date] ) , DATEADD( 'Calendar'[Date] , 2, YEAR ) )