Forum Discussion

Laveezai's avatar
Laveezai
Frequent Visitor
2 years ago

Getting Last row between two dates

Hello, here's my problem:

I have a table that logs each change to an Actual YTD. It includes the number, the attached project and the date the record was created.

 

 

I also have a table containing custom quarters on which I need to focus my analysis.

I'd like to be able to filter my Actual YTD table to retrieve only the last row of quarters 1, 2, 3 and 4.

 

For the moment, I'm not sure how to do this, as I first need to make the link in my model between my Actual YTD History table and my closing dates table.

 

I've made a link between  created on --- end date .

 

Do you know how to proceed?

1 Reply

  • you need read about of Slowly Changing Dimensions in Power BI