I have safety data. I’m trying to count total accidents this year vs SPLY.
Currently, I was using
Calculate ( [Total Acc], sameperiodlastyear([datecolumn]))
This works fine, I believe it will count all records through the same number of days last year.
Problem I encounter is when I want to do it by fiscal week. Week 1 vs week 1 last year, the calendar year dates aren’t aligned.
Not sure what kind of pattern I can use. Hopefully my issue is clear, can anyone assist?