Forum Discussion
bo_afk
Post Patron
Post PatronComparison vs same week last year
I'm trying to compare the sales from this week this year, vs the same week last year (based on week number). Whilst I do have dates in my data, I can't use the SAMEPERIODLASTYEAR function since th...
All, I finally managed to find a solution here in this link https://forum.enterprisedna.co/t/same-period-last-year-for-fiscal-week-nbr-weeks-in-sales-table-are-non-standard/240/8
What I had to do was to create a measure based on the measure that you all had suggested.
Greg_Deckler
Community Champion
Community ChampionSee 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