Forum Discussion

drudd75077's avatar
drudd75077
Regular Visitor
1 year ago
Solved

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.

 

My pbix file in a zip folder 

 

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