Convert Julian date to nomal date

Hi Aalice_hos ,

I found another topic about this issue:
https://community.powerbi.com/t5/Desktop/7-Digit-Julian-Date-conversion/m-p/122102

Try this calculated column as mentioned in that topic where
TheTable = your table name 
[JulianDate] = name of your julian date column

caldate =
DATE ( INT ( DIVIDE ( TheTable[JulianDate], 1000 ) ), 1, MOD ( TheTable[JulianDate], 1000 ) )

Sample output