Forum Discussion
Filter data based on prior year
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. !!
Years are just numbers. I think you just need to adjust the formatting for the column to no commas and 0 decimal places.
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
2 Replies
Years are just numbers. I think you just need to adjust the formatting for the column to no commas and 0 decimal places.
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