Register
Log In
Unanswered
Home
New Member
Dashboards
Power Pivot
Power BI
April 21, 2015
Offline
I am trying to figure out how to convert a column of ordinal dates to Gregorian, but I'm not at all proficient with M code. I found the below on a Power BI forum that was flagged as a problem solved, but it returns the day after for each date (it adds the day number of the year to 1/1/YYYY). Can anybody help me out with this, please?
Thanks!
Date.AddDays(Date.From(DateTimeZone.From("20" & Text.Start(Number.ToText(116343),2) & "-01-01")),Int64.From(Text.End(Number.ToText(116343),3)))
See Answer
July 16, 2010
Offline
Hi Kenny,
I don't profess to understand Julian dates, but you could just add another Custom Column to adjust the date returned by the above formula by 1:
=Date.AddDays([date column],-1)
Then you can delete the column containing the incorrect date.
Mynda
Answers Post
New Member
Dashboards
Power Pivot
Power BI
April 21, 2015
Offline
Thanks! I don't know why that didn't occur to me! I had been trying to do it in the same column.
Thanks again!
July 16, 2010
Offline
Hi Kenny,
I thought for a second on how to edit the formula in the same column too, but I'm lazy and it was going to require learning how those date formats work. It was just easier to add another column 😉
Mynda
Most Users Ever Online: 57
Currently Online: Catalin Bombea
8 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Janel Oz
Mohamed Rehan Memon
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
