Forum Discussion
Laveezai
2 years agoFrequent Visitor
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
- AhmedxSuper User
you need read about of Slowly Changing Dimensions in Power BI