Power pivot - performing a calculation just for the last row of a set

[atkach123]

Hi,

I'm currently trying to perform a calculation but I want it to run only for the last day of that week otherwise I want it to return a blank.

Here's an example:

So in total, this worker worked 74 hours for the week and his threshold after which he gets overtime is 60 hours for the week. So overall he is entitled to 14 overtime hours. In the last column of that example, I want to perform the calculation 74 minus 60 but only if it is the last day of that specific week, otherwise I want it to return a blank. I'm doing this in PowerPivot.


Thanks in advance!

 

[atkach123]

Link to example didn't post - here it is: Imagezilla.net - Adult Image Host, Non-Adult Image Hosting

 

[GorD]

From what i have read, I believe the best way to achieve this would be to have a linked calendar table ( think there is an automated way to do this (button) in excel 2016, more manual in earlier versions. Your pivot table would then summarise hrs worked per week and calculating overtime hrs should be asy