Clean inconsitstent date data in PowerBi

[PhilippMer]

Hello, 

i have run into an issue, in which i am not able to find a solution.

I have pulled data on how many views certain posts get from LinkedIn. So theoretically each day i am pulling the current views on the post, substracting from previous day and then I get my views per day. 

But my PowerAutomate did not work in some time intervalls and I did not fix it in time. So now I have inconsistent data, where lets say on the First of June one post hat 200 Views, the next data entry in my table is one month later, so the first of july and now it got 700. Obviously these 500 new views did not appear in one day, but in my Graph currently it is shown that way. 

Would someone maybe have an Idea, on how to just spread these 500 new views on the 30 days which have passed? so 500/30 in this case? 

This is the current result with these Outbursts. 

I have the date dimension and the table with dates from when the v

Thank you in advance!  

[lbendlin]

Power BI has no memory. You need to do that cleanup in the upstream system (the data source)