Forum Discussion
Helper ISame Period Last Year Invalid Return
Hello,
I am getting wrong values using the SAMEPERIODLASTYEAR measure.
I am getting wrong values using the SAMEPERIODLASTYEAR measure.
= CALCULATE ([New Hire],FILTER ( ALL ( 'FY Calendar'[Date] ), 'FY Calendar'[Date] <= MAX ( 'FY Calendar'[Date] ) ), SAMEPERIODLASTYEAR ( 'FY Calendar'[Date] ))What I am trying to get is the total headcount in the previous year. Any help will be greatly appreciated.So what's wrong with the result of the measure? To be general, you may modify your measure like pattern below and check if it can meet your requirement:
Measure = CALCULATE ( [New Hire], SAMEPERIODLASTYEAR ( 'FY Calendar'[Date] ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- Greg_Deckler
Community Champion
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008 
v-yuta-msftCommunity Support
I am getting wrong values using the SAMEPERIODLASTYEAR measure.
= CALCULATE ([New Hire],FILTER ( ALL ( 'FY Calendar'[Date] ), 'FY Calendar'[Date] <= MAX ( 'FY Calendar'[Date] ) ), SAMEPERIODLASTYEAR ( 'FY Calendar'[Date] ))What I am trying to get is the total headcount in the previous year. Any help will be greatly appreciated.So what's wrong with the result of the measure? To be general, you may modify your measure like pattern below and check if it can meet your requirement:
Measure = CALCULATE ( [New Hire], SAMEPERIODLASTYEAR ( 'FY Calendar'[Date] ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
