Getting the latest value per date and using intervals

Hi again,

I completed the thing, reading better it was clear, apologies for not understanding

Here is my result, with your sample data

Here is the file pbix:

https://drive.google.com/drive/folders/1beZLGE0rxZOeLOUVVF2DZ5l43ZBpxfCH?usp=sharing

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI