Forum Discussion
Solved
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]) ...
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
Years are just numbers. I think you just need to adjust the formatting for the column to no commas and 0 decimal places.