changing Gregorian to Hijri date error in power query

[Somayeh]

HI,

I have a date column in julian type that is based on Hijri calendar and I want to change the type of this column to date formate. 

I changed the format from whole number to text then using locale I changed it to date type in our locale. I checked the data loading ane reigon format setting option too. but I faced to "We couldn't parse the input provided as a Date value." for just 1 percentage of data in this column. in detailed it seems there are 5 specific days in solar hijri calendar which faced with error and repeat for all years after that.

How can I solve this problem?

Thanks in advance

somayeh

[Somayeh]

in the picture, we see the 0229,0230,0231,0431 and 0631 is repeated for each year (1393,1394,..)

[Vijay_A_Verma]

Which are those 5 dates?