Depends on the cause
Most patients will recover from metabolic causes once they are reversed, , this is the most common scenario.
So if someone is confused from a bad reaction to a drug they will get better once the drug is stopped, or if from kidney failure
they get better once the kidney's recover or with dialysis
. If the brain itself is directly injured ( stroke
, head injury
etc..) the recovery can be variable.