batespmNew Member2 years agoAttendance Data Hi, I have the below dax for attendance figure. CBL Attendance % = DIVIDE( SUM('WorkingArea TOUR_ClassBased'[Positive Marks]), SUM('WorkingArea TOUR_ClassBased'[Total Marks]) ) ...Show More
FreemanZSuper User2 years agoHi batespm , try like: measure = CALCULATE( [CBL Attendance %], date[date] >= TODAY()-21 ) or measure = VAR _currendate = MAX(date[date]) RETURN CALCULATE( [CBL Attendance %], date[date] >= _currendate -21 )
Related contentFive Reasons to attend SQLConAttendance StreaksCalculation with the missing the attendance dataThis is your sign to attend FabCon Atlanta—Data Warehouse EditionAttendance report that shows daily employee attendance even if no data was recorded
