Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

Attendance Points Assessment and Buyback

  • 1.  Attendance Points Assessment and Buyback

    Posted 17 days ago
    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