This Year vs Last Year

[sam.mckay]

Thanks for your patience.

Check out the technique discussed in the below forum post.

This is exactly how I would solve this so that you only show what you require in your Power BI report page.

Dynamic Date Query Table

What I would do in this case is create you date table to go out far into the future, for example 2020. Then within the date table add a calculated column with logic inside of it that shows up to today (or something like that) Then you will have a column that you can use in the report or page filter area. [image] Think of this like an automatic switch across your report that will produce the filters that you need, like you’re having to do manually at the moment. Here’s an example of the calc…