Forum Discussion
Kiven_03
2 years agoRegular Visitor
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...
- 2 years ago
Here is a radically different approach
Add all marks together and then subtract the smallest mark.
Kiven_03
2 years agoRegular Visitor
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
2 years agoSuper User
Here is a radically different approach
Add all marks together and then subtract the smallest mark.