Forum Discussion

Kiven_03's avatar
Kiven_03
Regular Visitor
2 years ago
Solved

Window Function for Student marks

Hi, I have issue in finding a solution, please help me with it.   I have a table "X_Marks", where columns are (ResultYear (ex: 2021-2022), School_ID, Roll_Number, Subject_Code, Marks). The Resul...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Here is a radically different approach

    Add all marks together and then subtract the smallest mark.

     

Kiven_03's avatar
Kiven_03
Regular Visitor
2 years ago

Hi lbendlin ,
Thank you for your reply,
I was trying to get the total of top5 subject marks out of 6 subjects of a student,

but thing is in student's Marks Table of 3 academic years  where student roll in not unique, but unique in each academic year.

 

Thank you. 

lbendlin's avatar
lbendlin
Super User
2 years ago

let's say you have the following marks

 

87,87,83,83,83,83

 

What in your opinion should be the top 5 subjects?

  • Kiven_03's avatar
    Kiven_03
    Regular Visitor
    2 years ago

    Thanks for your reply lbendlin ,

    87,87,83,83,83 should be my total of Top5 Subjects and one subject marks needs to be eliminated '83'. 

    But now I got new doubt, thank you for your valuable reply.

     

    Anyhave please help me with the current senario.

     

    Thank you

    Vivek

     

     

  • Kiven_03's avatar
    Kiven_03
    Regular Visitor
    2 years ago

    lbendlin I was trying to eliminate the 6th value using window function INDEX or MIN function,

    but struggling to create a DAX for the expression for it, maybe it bring me the result.

    Please help me with it and I appreciate for your time.

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Here is a radically different approach

      Add all marks together and then subtract the smallest mark.