Forum Discussion
Solved
How to convert the integer into date for calculation?
Hi, All, I got a table as follow: Date Year Period Result 2011-9-6 5 2016-9-6 2012-6-3 4 2016-6-3 2003-4-5 5 2008-4-5 Is there any way to add the Year Period(Integer) to ...
Hello,
You can do it this way:
Result = DATE(YEAR('Table'[Date])+'Table'[Year Period], MONTH('Table'[Date]), DAY('Table'[Date]))If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Hello,
You can do it this way:
Result = DATE(YEAR('Table'[Date])+'Table'[Year Period], MONTH('Table'[Date]), DAY('Table'[Date]))
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Thank you, JoBI~
It works~ Thank you so much~ 😀