topic Sameperiodlastyear () issue in DAX Commands and Tips

Sameperiodlastyear () issue

Prasad_chattu — Tue, 04 Mar 2025 04:40:49 GMT

Hey everyone ,

I was trying to check the "last year incidents" through Sameperiodlastyear() dax function.

Total Incidents = DISTINCTCOUNT(Reported_Incidents[Incident No])

Last_Year_Incidents = CALCULATE([Total Incidents],SAMEPERIODLASTYEAR('Date Table'[Date]))

Getting same year values.

Verified :
1. Created a Separate "Date Table" and Marked it as "Date" table.

2. Have 1 to Many Relationship between "Date Table" and "Incidents Table".

Am i missing something here ??

OwenAuger — Tue, 04 Mar 2025 04:55:40 GMT

Make sure that the Year column used in the visual is 'Date Table'[Year].

Based on the measure values in the screenshot, it appears that the Year column may be from Reported_Incidents or another table.

Does that fix it?

Prasad_chattu — Tue, 04 Mar 2025 05:04:19 GMT

Yes its fixed. Thank you OwenAuger