We provide the homeless community a snack and soda voucher that works at all 5 shelters in the city.
Each voucher is good for a total of 5 free sodas and 10 free Hot Dogs between July1 and June 30.
We capture this data in a database but need a daily report to print for each site so the workers can mark each person daily, no matter which shelter they go to.
I need help writing the dax that shows how many of each product a person has been given and how many remain. I do not care where they used the voucher, I just need a running total so that our other team has time to apply for a new voucher if necessary.
The final report lay out should look like this:
Customer Name | Allowed HD | Provided HD | Remaining HD | Allowed Soda | Provided Soda | Remaining Soda
Amy 10 6 4 5 1 4
Jane 10 2 8 5 5 0
Willie 10 9 1 5 4 1
Thanks in advance
Table Name = FoodGrant
Fields = Customer Name, Products (soda, hot dog, chips), Shelter (L1,L2,L3,L4,L5), Voucher Date
