Add Integer Column to Date Column

[ss89]

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! 

[FreemanZ]

hi @ss89 

As suggested by Greg, you can try to add a column like:

DueDate = [DATE_IN] + LOOKUPVALUE(...)

[Greg_Deckler · Accepted solution]

@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.