Forum Discussion
ss89
3 years agoHelper II
Add Integer Column to Date Column
Hello Community, I am trying to add an integer column and a date column (DATE_IN ) to get arrive a new column called Due Date. Which formula can I use in Power BI? Thanks in advance...
- 3 years ago
ss89 Just use + operator like [Date] + [Some Integer Column].
DAX Dates are decimal numbers where the integer portion is the number of days since December 30th, 1899 and the decimal portion is fractions of a day, like 1/24/60/60. So, just adding an integer to a date adds that many days to the date.