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

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 ) )