Forum Discussion

diogobraga2's avatar
diogobraga2
Helper IV
5 years ago
Solved

Calculation to return value based on maximum date and maximum year

The goal is to create a dynamic calculation that will show the 'Returning Rate' for the maximum 'Date Adj' for the maxium 'Academic Year' per school per grade.  Based on this dataset the 'Return...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    To a matrix visual, i dragged the School Code anf Grade Level and then wrote these measures

    Measure = MAX('result (5)'[Academic Year])
    Measure 2 = MAX('result (5)'[Date])

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

To a matrix visual, i dragged the School Code anf Grade Level and then wrote these measures

Measure = MAX('result (5)'[Academic Year])
Measure 2 = MAX('result (5)'[Date])

Hope this helps.