Same Period Last Year Invalid Return

[PatrickLamoste]

Hello,

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.

Thank you!

[v-yuta-msft · Accepted solution]

@PatrickLamoste,

---

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.

[Greg_Deckler]

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-TIT...