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 IHere's a link to the example data.
https://drive.google.com/file/d/1EJp9tLNA2_fVfzz4HkV9sBMYLCUAGavO/view?usp=drive_link
I'm looking to add a second column via a measure that gives the previous month's totals by Parent, based on the slicer selection. I know this is easy to do with the prevmonth/qtr/year functions, but this data set is by week. After thinking about it, i wonder if i need to create a table for the previous week's balances within the measure? that's a bit above my pay grade so i'm not sure how to get that done.
- lbendlin
Super User
can you please check the link? access is denied.
- MikeBresnan
Sorry about that, link is fixed
- lbendlin
You have the same sample data for both weeks