This is how you can create a material in Unreal Engine 5 that changes its texture based on your distance to the object. Use the Distance_Blend function to display a material for both near and far.
https://dev.epicgames.com/community/learning/tutorials/71My/unreal-engine-fortnite-distance-based-textures-for-meshes-and-landscapes-distance-blend