Forum Discussion

joaodd's avatar
joaodd
Frequent Visitor
2 years ago

How to include a dinamic variable into a temporary column

I have a table "REGISTRATION" with 3 fields: - StudentNumber - Date - Status This table registers any change in the student status, each time the student status changes it is registered in this ...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

You need to protect SELECTEDVALUE from FILTER.  Move it out into a variable.

 

Active Students = 

var sd = selectedvalue('Calendar'[Date])

...

FILTER('REGISTRATION', 'REGISTRATION'[Date] < sd,

...

 

etc

 

Can you please re-enable the download?

    • joaodd's avatar
      joaodd
      Frequent Visitor
      2 years ago

      Hi lbendlin , thanks for your inputs.

      The key objective is not to know how many students registrations switched to ACTIVE on each day, but rather how many have the status ACTIVE on a given date.

      Thanks  

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        yes, that's what my proposal is doing - number of active students on a given day.