Filter data based on prior year

[tameismael]

Hello everyone,

In my table I added a new column I inserted the below formula :

Prior Year = IF(‘Table1’[Column1].[Date]<TODAY(),'Date Dimension'[PriorYearEndDate].[Year],TODAY().[Year])

I tried to implement the above formula in order to filter my data based on prior year but wasn’t successful and when I deleted the year part as highlighted above [Year], it got implemented but it didn’t give the correct results as years instead it gave me the numbers as  the below image in filters section. So as a result I need to see years in the filter section not Numbers. !!

[AlexisOlson · Accepted solution]

Years are just numbers. I think you just need to adjust the formatting for the column to no commas and 0 decimal places.

[amitchandak · Accepted solution]

@tameismael , Not very clear, what you want to achieve here

You need this year vs last year flag

Year Type = Switch( True(),
year([Date])= year(Today()),"This Year" ,
year([Date])= year(Today())-1,"Last Year" ,
Format([Date],"YYYY")
)

if you need measures refer 

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA

[AlexisOlson · Accepted solution]

Years are just numbers. I think you just need to adjust the formatting for the column to no commas and 0 decimal places.