Forum Discussion

thaonguyen's avatar
thaonguyen
Frequent Visitor
3 years ago
Solved

Only compare 1 value per week

Hi all,  This is my data: Name Day Required Date Attendance Date tien.nguyen 9/1/2022     tien.nguyen 9/2/2022     tien.nguyen 9/5/2022 9/5/2022 9/5/2022 tien.nguyen 9/6...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi thaonguyen 

    Please create a calculated column like this :

     

     

    Column = 
 var _count=CALCULATE(COUNT('Table'[Attendance Date]),FILTER('Table',WEEKNUM([Day],2)=WEEKNUM(EARLIER('Table'[Day]),2)&& WEEKNUM([Attendance Date],2)=WEEKNUM([Required Date],2)&&[Attendance Date] in VALUES('Table'[Required Date])))
 return IF([Required Date]<>BLANK(),IF(_count=2,"Comply1",IF(_count=1,"Comply2",IF(_count=BLANK(),"Violate"))))

     

     

    The result is shown as below .

     

    Best Regards,
    Community Support Team _ Ailsa Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi thaonguyen 

Please create a calculated column like this :

 

 

Column = 
 var _count=CALCULATE(COUNT('Table'[Attendance Date]),FILTER('Table',WEEKNUM([Day],2)=WEEKNUM(EARLIER('Table'[Day]),2)&& WEEKNUM([Attendance Date],2)=WEEKNUM([Required Date],2)&&[Attendance Date] in VALUES('Table'[Required Date])))
 return IF([Required Date]<>BLANK(),IF(_count=2,"Comply1",IF(_count=1,"Comply2",IF(_count=BLANK(),"Violate"))))

 

 

The result is shown as below .

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.