Forum Discussion

Dalylah_23's avatar
Dalylah_23
Regular Visitor
5 years ago

Keep data set to yes

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.

3 Replies

  • HashamNiaz's avatar
    HashamNiaz
    Icon for Solution Sage rankSolution Sage
    5 years ago

    Hi !

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

     

    Regards,

    Hasham

    • Dalylah_23's avatar
      Dalylah_23
      Regular Visitor
      5 years ago

      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's avatar
        Dalylah_23
        Regular Visitor
        5 years ago

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