topic Re: Filter data based on prior year in DAX Commands and Tips

Filter data based on prior year

tameismael — Thu, 07 Oct 2021 15:45:55 GMT

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. !!

Re: Filter data based on prior year

AlexisOlson — Thu, 07 Oct 2021 16:36:52 GMT

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

Re: Filter data based on prior year

amitchandak — Thu, 07 Oct 2021 16:37:07 GMT

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