Attendance Points Assessment and Buyback

[davidjimenez18]

I'm barely new with DAX and I'm trying to make an Attendance Points Tracker in Power Bi based on the attendance policy that we have on the company, I  was able to create the tracker and everything was going ok but now I need to find a way to remove points when the employee has an excuse or something. The way I'm assessing point right now is that I'm taking the schedule report and then summing the "absent codes" time and depending on the number of hours absent they get points. But I need a way to actually remove the points or add a minus (negative) amount to the points so that I maintain not only what they currently have but what they accrued at one point.

I have attached the Bi report as an example for you guys to help. Any assistance will be greatly appreciated, thank you in advance.

https://www.dropbox.com/sh/9m52u7fcu07suhk/AADRmKELfZBKPbCIzfRRwLCpa?dl=0 

[lbendlin]

Power BI is a reporting tool.  It has no memory.  Any special rules that require history based logic will most likely mean that you need to that in a more appropriate tool. A time management tool, for example?

[davidjimenez18]

Yeah, I'm not trying to use it as memory rather than using our reporting tool to report the attendance points our agents are accumulating as they go. The memory would be the dataset from where I assess the points. 

I just need help figuring out how to fix the below issues I'm facing right now. 

1. Cumulative points returning some blanks and some values

2. I need to add minus points to this points as we waive some of them, I have a separate table with the Waived points and I tried just adding it to the Point assessment measure as a negative but that dind't work.