Hi team,
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.
------------------------------
David Jimenez
Business Financial Analyst
------------------------------