Dax assistance

[Anonymous]

Good evening

i am looking for some assistance. 

I have a table which has attendance recorded per day. I then have a celndar table which I'm created using dax as the calendar is based on academic not fiscal. Everything is working as it should and I've got relationships with all my tables. I've then got some summarise tables created to merge the attendance marks together onto two columns one is possible and one is present. The percentage is present over possible. I have a if statement then working out if the % is 100% for the week there is points awarded which is working a great. But if at the end of the academic term which in this case in two weeks time, if the % is 100 for the whole term a bonus 100 Pts are awarded. The issue I've got is the 100 pts is being awarded before the end of the term as power bi sees this as right which is theory is. But I want the 100 0ts to only be awarded at the end of the term. Is this possible sorry I've not been able to share this data as the tables are huge

[Greg_Deckler]

@Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.