Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Gaucho
Helper I
Helper I

Julians Date

Hello,

How can i convert this Date to normal Date.

 

Gaucho_0-1688460435041.png

Thx in advance for your help

16 REPLIES 16
Idkpowerbi
Helper I
Helper I

Hello Gaucho.

I think what you are asking is to display date in format of dd:mm:yyyy

You can change that here

 

sol_1.PNG

Hi @Idkpowerbi 
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

Please show

  • Your original data
    • If your data is confidential, then make up some data that demonstrates the problem 
    • Best to post this as text or an Excel table which can be copy/pasted.
  • A screenshot of your desired results from that data
  • Your current code
    • To obtain this:
      • Select "Advanced Editor"
      • Copy the contents of the window that opens
      • Open the Code Sample window here `</>`
      • Paste the code into the Window
  • A statement of your logic in going from your original data to your desired results

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.

slorin
Super User
Super User

Hi

 

= Table.TransformColumns(Prev_Step,{{"GJ", each Date.FromText(_, [Culture = "de-DE"]), type date}})

Stéphane 

Hi it is not fonctioning, here is the error message;

Gaucho_0-1688467141626.png

 

Add column

Date.FromText([GJ], [Culture = "de-DE"])

Stéphane 

@slorin still not fonctioning

Gaucho_0-1688476286499.png

 

I need more information

What is the formula?
What is the error message?

 

Stéphane

Gaucho_0-1688477100376.png

Here ist how GJ is appearing, when i try to insert the code you gave me it shows no error as shown below:

Gaucho_1-1688477271567.png

When i click on "OK" the result appears like this:

Gaucho_2-1688477328662.png

 

 #date(2023,1,Number.From([GJ])

 

In "GJ" i have the year 21, 22 and 23. THe formular you gave me will be like this;

Gaucho_0-1688480665767.png

 

I don't understand what do you want : 01/01/2021, 01/01/2022 and 01/01/2023 ?

#date(Number.From("20"&[GJ],1,1)

 

I want something like this;
all dd/ all MM/YYYY for 2021, 2022 and 2023

The syntax is showing no error but when i click on Okay, it shows me "ERROR"

I can't help you without your formula, a screenshot, your previous step, the error message...

I took de Data with "GJ" in JDE but i couldn't convert it to date, that is why i was trying to get a solution how to manage it .

Helpful resources

Announcements
Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.