Forum Discussion

DHB's avatar
DHB
Helper V
2 years ago
Solved

DAX Expression Fail

Hi all,   I wonder if you could help me with a bit of DAX.  I have a list of students (ECON_1008 Enrols) joined to a list of dates on which they were active online (one to many).    Now I’m only ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    This calculated column formula works

    Column = if(CALCULATE(COUNTROWS('Students and courses'),FILTER('Students and courses','Students and courses'[Course_Start]<=EARLIER(Activity[Activity Date])&&'Students and courses'[Course_End]>=EARLIER(Activity[Activity Date])&&'Students and courses'[Student]=EARLIER(Activity[Student])&&'Students and courses'[Course]=EARLIER(Activity[Course])))<>BLANK(),"Valid","Invalid")

    Hope this helps.

     

DHB's avatar
DHB
Helper V
2 years ago

Thank you Ashish_Mathur that works perfectly.  I really appreciate your time.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

You are welcome.