Piles with continuous helix (referred to herein as "screw pile") is a new configuration of helical piles. It features a continuous helix spiraling several pitches around a smooth shaft forming a "threaded shaft". This study investigates the compressive capacity and behavior of helical and screw piles using 3D numerical models calibrated and validated against full-scale field testing. The bearing capacity factor, Nc, for helical piles is back-calculated from the numerical results and compared against standard theoretical assumptions to evaluate their accuracy in predicting ultimate capacity. Parametric studies are conducted considering screw piles configuration, including shaft diameter, pitch size, helix diameter, as well as soil strength. The results reveal that shaft resistance accounts for up to 89% of the total capacity. Analysis of load distribution, shear contours, and displacement contours at failure allowed for the identification of different failure modes of soil adjacent to the pile’s threaded shaft: Individual Bearing Mode (IBM), Cylindrical Shear Mode (CSM), and a combined mode. The study identifies specific parametric thresholds for these modes in both sand and clay layers. Furthermore, varying clay strength is found to alter the development of the shear surface, transitioning from localized bearing to continuous shearing along the threaded shaft. Finally, apparent shaft resistance factors, α and β, are back-calculated to provide ractical parameters for evaluating the resistance of threaded shafts in layered soil.