Skip to main content

    Power BI

    New

    Julian Date to Calendar Date Conversion

    Vote (11) Share
    Daryl Musser's profile image

    Daryl Musser on 10 Jul 2017 19:01:28

    Would be great if Power BI would recognize a 6-digit Julian Date column and convert to a calendar date. Or at least provide a function to do so.

    Comments (2)
    Daryl Musser's profile image Profile Picture

    bc7ba5a3 ff95-4d41-b817-915a5bb74166 on 05 Jul 2020 23:54:27

    RE: Julian Date to Calendar Date Conversion

    Have you found an easy solution to this problem since it hasn't been implemented?

    Daryl Musser's profile image Profile Picture

    c65ad1bc c264-47b7-aed9-2ce7bd118f8c on 05 Jul 2020 23:52:48

    RE: Julian Date to Calendar Date Conversion

    I agree, a lot of companies, and labs use the Julian Date format. I am new to Power BI, and found it odd that its not available.

    It seems like Labs, Food, and pharmaceutical companies would want this feature. It seems like it would make some of the time date calculations a little easier too.

    My good Sir I am proud to be vote number 8! :-)