I have a table of employees summarized like below that is connected to a Power BI dataset. The business is asking for an exported paginated report to be able to filter this data to a certain date to go back in time to see what the company looked like. For example, if they filtered to 11/20/2023 it would show rows 2,4, and 6. But if it was 12/31/2023, only 4 and 6 would show etc. I did something similar in Power BI which is also connected to the same dataset where I added a Calendar table and put a measure that was written like this: