After the s5 finale, Dean tries it with Lisa and it ends pretty fast. Dean blames himself and his fucked up past, so he wishes he could just forget everything. Cas overhears and grants him this, erasing Dean's memories of being a Hunter and a brother.