Forum Discussion
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....
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]))
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.