% diff of rows based on two columns

[Anonymous]

Hi guys,

I have 15 minutes data date table.. so it looks like this 

1-1-2018 12:00 AM ---- city 1 ---60

1-1-2018 12:15 AM --- city 1 ---- 50

1-1-2018 12:00 AM --- city 2 ---- 30

1-1-2018 12:15 AM --- city 2 --- 40

A) I want to calculate the difference between each time for every specific city, so (50-60)\60 would be ~-16% ... so this should be with time exactly before it.. for the same day... and I also want the difference between the values for the same time but in comparison to previous date... like if I had 2-1-2018 12:00 AM --- city 1 --- 70 then it would be compared with the 60... 

B) I made a chart of max values by minutes, so x axis = 12:00am,12:15 am and the max value happend at that time... the problem is, I want to know to what city and what date this has happend? is this possible? 

thanks,

[v-yuta-msft]

@Anonymous ,

---

@Anonymous wrote:

Hi guys,

I have 15 minutes data date table.. so it looks like this 

1-1-2018 12:00 AM ---- city 1 ---60

1-1-2018 12:15 AM --- city 1 ---- 50

1-1-2018 12:00 AM --- city 2 ---- 30

1-1-2018 12:15 AM --- city 2 --- 40

A) I want to calculate the difference between each time for every specific city, so (50-60)\60 would be ~-16% ... so this should be with time exactly before it.. for the same day... and I also want the difference between the values for the same time but in comparison to previous date... like if I had 2-1-2018 12:00 AM --- city 1 --- 70 then it would be compared with the 60... 

B) I made a chart of max values by minutes, so x axis = 12:00am,12:15 am and the max value happend at that time... the problem is, I want to know to what city and what date this has happend? is this possible? 

thanks,

---

Could you share expected result?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.