Have a Static Mesh fade in/out

You may select “Surface TranslucencyVolume” for Lighting Mode in material’s Translucency settings in order to enable normal, metallic and roughness with opacity.