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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors