Forum Discussion
DarylM
Helper II
Helper IIConvert Julian Date to Calendar Date
Does anyone know how I can convert a Julian date (Example "116343") to a calendar date? Struggling with a Dax formula for this. Thanks!
Yes you can reference a column name instead of a constant. It is what is recommended.
DarylMHelper II
Helper III did find a formula in DAX and M that works create in converting a 6 digit julian to a date.
DAX
DATE(INT(BISalesView[Date Julian]/1000)+1900,1,MOD(BISalesView[Date Julian],1000))
M Language (Query Editor)
Date.AddDays(#date(Number.RoundDown([Date Julian]/1000)+1900,1,1),Number.Mod([Date Julian],1000)-1)
Hope this helps!
