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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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. 

ronrsnfld
Community Champion
Community Champion

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors