Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Solved! Go to 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])
Apologies for the delayed reply. This solution worked! Thanks!
Apologies for the delayed reply. This solution worked! Thanks!
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
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
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])
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
82 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
129 | |
108 | |
63 | |
55 |