Forum Discussion

ss89's avatar
ss89
Helper II
3 years ago
Solved

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...
  • Greg_Deckler's avatar
    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.