turning sporadic data points into regular ones

ScottPat , this approach can help

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee884e

But I think index function with sort on date along with month should also help

Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U

calculate([Meausre], index(1, allselected(Date[Month], Date[Date]), orderby(Date[Date],desc),,partitionBy(Date[Month]) ) )