Forum Discussion
Day to Date format
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.
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])
5 Replies
- HotChilli
Community Champion
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])
v-piga-msftResident Rockstar
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