Keep data set to yes

[Dalylah_23]

Fairly new at power bi. I have a yes/ no column. Is there a way that I can set the data to stay at yes once it changes from no to yes? Once it changes over to yes it can no longer be changed to no.

[HashamNiaz]

Hi !

Please provide some more nformation, about data source your table structure. Does the table keeps updated.

Regards,

Hasham

[Dalylah_23]

So I have three tables a checkout device, checkout day and assigned table which is a yes or no column.  This will show me which devices that are checkout have been assigned. Once they're assigned I don't care if they get unassigned at a later date as long as they get assigned once.. Which is where I'm having difficulties with my yes or no column because it can switch back to no if the device gets unassigned. 

[Dalylah_23]

Sorry meant to say three columsc checkoit device, checkout date and assigned