All these three things are necessary to get a properly typed numeric column in your Power Query query – if you vary from this too much then folding won’t happen. It’s also possible to use this ...