The text of your post seems to be at odds with the code and the post's subject regarding the "FILE_Type" property! Your code says to get the file extension, but the the text asks for it to be either the string "Directory" of "File".
See if this is any help:
$dir = "C:_Files"
Get-ChildItem $dir -Recurse -Depth 0 |
ForEach-Object {
[PSCustomObject]@{
NAME = Split-Path $_.FullName -Leaf
FILE_COUNT = (gci -File $_.FullName -Recurse).count
FOLDER_COUNT = (gci -Directory $_.FullName -Recurse).count
DIRECTORY_PATH = $_.FullName | Split-Path -Parent
SIZE = "{0:N2} MB" -f ((gci $_.Fullname -Recurse | measure -Property Length -Sum -ErrorAction SilentlyContinue).Sum / 1MB)
FILE_Type = If ($_.PSIsContainer){"Directory"} else {"File"}
Character_Count = $_.fullname.length
Created = $_.CreationTime
Modified = $_.LastWriteTime
}
} | export-csv -Path "C:\Junk\Dept.csv" -NoTypeInformation
Why have you used the "-Recursive" switch and then set the depth to "0"????