Calculate Separate Moving Value dependant on date and other columns

[BugmanJ]

Good Day All,

I have the following dataset. You will note that its not in any real order and that this data is added to daily

Cookie Jar Level	Cookie Jar	Date	Customer	Shop
90	Blue	02-Feb-23	Billy	NYC
52	Green	03-Feb-23	Anne	NYC
101	Red	02-Feb-23	George	NYC
55	Blue	05-Feb-23	Salay	Denver
73	Red	05-Feb-23	George	NYC
70	Blue	04-Feb-23	Billy	NYC
42	Green	04-Feb-23	Anne	NYC
65	Blue	05-Feb-23	Billy	NYC
55	Green	01-Feb-23	Anne	NYC
80	Blue	03-Feb-23	Billy	NYC
100	Blue	01-Feb-23	Billy	NYC
85	Red	04-Feb-23	George	NYC

And what I need to create is data that shows the difference between the Cookie Jar Levels for each Date/Date/Customer/Shop. It call be called "Change since last date".

How can this be done?

Thank you

[BugmanJ]

Hi @lbendlin 

Your view is confusing but take Billy and hence blue cookie jar in NYC.

I need a value which tells me the difference between day, so for him it would be 10,10,10,15

but I need that for every jar

[lbendlin]

Wouldn't these values be negative?

Billy Blue has values for each day. What do you expect to see for Anne Green?

[BugmanJ]

Technically yes, but if its a calc, i can turn it into a postive.

For anne green, it just be 3, 10. Sure be nice if could work out number of days and then divide the difference by that number but since struggling to do this its probably beyond power BIs abilities.

[lbendlin]

 Sure be nice if could work out number of days and then divide the difference by that number 

that can be arranged. So For Anne Green on 2/2/2023 it would be 53.5  and 1.5 delta?

[BugmanJ]

That would correct @lbendlin 

[lbendlin]

What is "last date"?

Based on this view, what would be the expected outcome?