Attendance Data

[batespm]

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

[FreemanZ]

Hi @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

)

[Rupak_bi]

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.