Create a Prior Year Column Based on a Filter Value

[drudd75077]

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.

[amitchandak · Accepted solution]

@drudd75077 , I check the file. Change your join to date from year_period  (for both tables)

[drudd75077]

That worked, thank you!