Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I want to add six weeks to my planned date column but for one cell February came back as 31 days, when we know its only 28 days this year.
I used : Date.AddWeeks([Planned Sprint],6)
Planned date: 19/11/2019 - Caculated date: 31/02/2020
How do I correct 31/02/2020 to 28/02/2020?
Thanks
Liz
Solved! Go to Solution.
Hi @Anonymous
I can't reproduce your problem.
As tested with this funtion, it shows expected value.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It isn't possible to have a 31/2/2020 date. February never has 30 or more days. But Feb 29, 2020 is legit. You can see at the top I'm using the same Date.AddWeeks() function.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi,
Sorry I look at the wrong data set. I've sorted it out now.
Thanks for your time and assisstance.
Liz
It isn't possible to have a 31/2/2020 date. February never has 30 or more days. But Feb 29, 2020 is legit. You can see at the top I'm using the same Date.AddWeeks() function.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @Anonymous
I can't reproduce your problem.
As tested with this funtion, it shows expected value.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm not sure I follow.
First there are 29 days in Febuary this year, not 28.
Second, November 11th 2019 + 6 week = December 31st 2019, or 31/12/2019
If you are sure you are seeing a Febuary 31st date. Is this possibly a string instead of a date? Power Bi will reject any attempt to create that date.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.