Day to Date format

[Anonymous]

Hi,

I have day of the year. I need to populate date from the day. I cant find which date function to use. I converted the data type from number to date, but it returns the previous date. with year as 1900. See sample below. Please help!

Day of the year	Date in Power BI	Actual Date
281	7th October 1900	8th October 2018
282	8th october 1900	9th October 2018

Thanks in advance.

[Anonymous]

Apologies for the delayed reply. This solution worked! Thanks!

[Anonymous]

Apologies for the delayed reply. This solution worked! Thanks!

[v-piga-msft]

Hi @Anonymous,

By my tests, the fomula of HotChilli should solve your problem.

If you solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[Anonymous]

Try HotChilli's solution first.

Microsoft counts date from 1st January 1900. So the 281st day happened to be the day 7th October 1900.

This silly hack may work:

Date = 'Table'[Day of the Year]+43103

[HotChilli · Accepted solution]

I haven't really tested this but the DATE function deals with numbers in a way that should help you.

'date calc'[day] is your 281, for example.

Column = DATE(2018,1,'date calc'[day])