Forum Discussion
Solved
turning sporadic data points into regular ones
i have some data that represents purchases over time it might look something like the below DATE Value item jan 1 5 spoon jan 5 ...
ScottPat , this approach can help
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
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]) ) )
Sorry I had just allocated values based on the state at the 1st of the month. To me that difference was not important as the key thing is to get the concept.
that has of course has been answered by amitchandak in the other reply
thanks, accepting that as the answer.