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 IIThank you.
I was incorrect on something though in my example. the date is accually afive digit code (16343). I was not abel to modify your formula to work with the fivei digits, Also, I would need this to work in a table and column of many julian dates. Can I reference the column name rather than the Julian date in the forumla?
bidgeir
Most Valuable Professional
Most Valuable ProfessionalYes you can reference a column name instead of a constant. It is what is recommended.