How to visualize/analyze only recent data while keeping historical records

[samsa18]

Hi everyone,

Learning PBI currently, and need help. From the sample table below, I have data that I update frequently leaving a trail of historical records. I have one of my analysis set up, however, it isn't correctly showing the right answer because of how the dates work. The easiest solution I can think of is to make so it only analyzes the most recent data everytime and visually show it on the log. The most recent data currently is September 13. Currently, the PBI is analyzing and visually showing every data & date. I do still want to be able to filter through the historical log.

For example, visually the most recent data is always displayed and analyzed. But I still want to be able to keep the historical data hidden but still visible only when I filter (This part I'm sure I can figure out by creating a page navigation)

[MahyarTF · Accepted solution]

Hi,

Not sure if I could understand.

But if there is any field that it is indicated the historical/current data you could put it in the filter pane for your visual/page/report.

Or if each day the data is archived, you could create the column/measure in your table and put it as max(date) or today() and then set the particular column/measure in your filter pane

If you are looking for others would you please say a sample as a current and expected result here ?

thanks for Kudos