Forum Discussion

batespm's avatar
batespm
New Member
2 years ago

Attendance 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])
)
 
Is there a way to amend this so i get the last 3 weeks attendance?
 
Thanks

2 Replies

  • Rupak_bi's avatar
    Rupak_bi
    Super User
    2 years ago

    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's avatar
    FreemanZ
    Super User
    2 years ago

    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

    )