No it is not what i am trying to do. In My screenshort you can see that there is always "1900". That is already problem i want to solve.
I cannot understand your logic in getting from what you show to what you want
As an aside, you are not showing any Julian dates (or dates from a Julian Date Calendar) in the data you have shown us so far, so I especially don't understand the significance of your question title.
Here ist how GJ is appearing, when i try to insert the code you gave me it shows no error as shown below:
When i click on "OK" the result appears like this:
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.