Forum Discussion

Hariharan_R's avatar
Hariharan_R
Icon for Solution Sage rankSolution Sage
7 years ago

Filter and Dynamic Result

Hi      I have below tables and i need to get "Default/Bonus" (red colour columns) column on Trans table. Also mentioned the logic for the columns.     We will be using RLS to filter the student....
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Create a measure in Trans and copy paste following dax:

 

Measure = IF(MAX(Trans[CourseDateTime])>MAX(Score[Startdate])&& MAX(Trans[CourseDateTime])<MAX(Score[Enddate]),MAX(Score[Bonus]),MAX(Score[Default]))
 
Let me know if that helps. :)
  • Hariharan_R's avatar
    Hariharan_R
    Icon for Solution Sage rankSolution Sage
    7 years ago

    It is not giving the expected result. 

     

    Score table's year and Trans table's year should be considered and the value is based on the student logs in. if student B logs in then subject S2 only considered on the Trans table new columns.