A light in a dream indicates that you have a psychic / intuitive gift. You have the ability to shine light into aspects of yours and other people’s lives.
Turning on a light indicates you are doing something in waking life that is illuminating what you need to be doing now. Turning off a light is saying the opposite. You are avoiding the steps you need to take in reality.
Lights off upstairs in a house indicate you are depressed or heading towards depression. The rest of the dream will explain what is triggering this. For example, if you see an old woman with her hair in a bun walking upstairs towards where the lights are off means that your depression is linked with issues around your mother (old woman), and how her conditioning restricts your thinking (hair tied up).