Forum Discussion
drudd75077
1 year agoRegular Visitor
Create a Prior Year Column Based on a Filter Value
So I am trying to create a visualization that will show the prior year amount for the same period in a different column based on my slicer. So slider is filtered for 2024_P02 this has a date associated in my calendar table of 2/1/2024. I want the current period to show up in the Amount Column. I do want the Same Period Last Year column to have the prior year for the same period. I tried using sameperiodlastyear function, but it didn't return anything.
Let me know if you ahve any questions. I really can't figure this how most examples online show a table with dates as the row values which isn't the case here. The context is really what I select for my slicer.
2 Replies
- amitchandakSuper User
- drudd75077Regular Visitor
That worked, thank you!