Forum Discussion
MikeBresnan
Helper I
Helper IGetting previous period values based on slicer
I'm sure there is one little aspect i am missing in the measure i pulled from a post on this forum, but i'm trying to get the previous date (i have a weekly balance table where each row is a differe...
You have the same sample data for both weeks
MikeBresnanHelper I
Helper II remember why i overcomplicated this now.
The data i'm pulling in is the balance as of Friday of each week. Previous week is covered thanks to lbendlin , but I also need to display the balances at the end of the previous year, and the friday of the same week in the previous year. I tried to use DATEADD, and subtract a year, but the actual day value doesn't line up. subtracting 364 days works, but that wont scale.
I updated the data in the link to include data for those additional dates, as well as some further failed attempts to get there. I'm thinking i need to leverage week numbers, but the weeks aren't lining up (8/26/2022 is week 35, and 8/25/2023 is week 34) either.