topic Attendance Data in DAX Commands and Tips

Attendance Data

batespm — Fri, 24 Nov 2023 15:56:30 GMT

Hi,

I have the below dax for attendance figure.

CBL Attendance % =

DIVIDE(

SUM('WorkingArea TOUR_ClassBased'[Positive Marks]),

SUM('WorkingArea TOUR_ClassBased'[Total Marks])

)

Is there a way to amend this so i get the last 3 weeks attendance?

Thanks

Rupak_bi — Fri, 24 Nov 2023 18:30:25 GMT

If you have a week number column in the table, you may try below

attendance% =

var positivemarks= sumx(topn(3, table, week number),positive marks)

var totalmarks= sumx(topn(3, table, week number),total marks)

return
positivemarks/totalmarks

you may use same concept if you have date cloumn to get last 21 days value.

FreemanZ — Sat, 25 Nov 2023 02:36:39 GMT

try like:

measure =

CALCULATE(

[CBL Attendance %],

date[date] >= TODAY()-21

)

measure =

VAR _currendate = MAX(date[date])

RETURN

CALCULATE(

[CBL Attendance %],

date[date] >= _currendate -21

)