Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper IV
Helper IV

Filter date by most recent non-blank year backwards

Hi all,


So we a situations where our most recent KPI scores are released on different years. One KPI might have its most recent score in 2019, while another might have its most recent score in 2017. I need to show 3 years of data, much like the picture below:




Here, the most recent figures has been released in 2019, so we get three year rolling backwards. We can call this KPI X.


In the picture below, KPI Y's most recent figure is from 2018. We have 2016 data, but the year column is stuck on 2017-2019:



Is it possible to make it so that the year filter is dynamic, and adjusts to show the most year of data on the right, followed by the preceding two years of data?



Community Support
Community Support



You may refer to the post below to add a calculated column.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-chuncz-msft 


I dont quite understand this. Could you please explain in a bit more detail?

Im sorry, I dont quite understand how that formula works? Could you please explain what it's doing?

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.