

New Member
Dashboards
Power Pivot
Power BI

April 21, 2015

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)))


New Member
Dashboards
Power Pivot
Power BI

April 21, 2015

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