Forum Discussion
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 for your support!
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.
2 Replies
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.
