Adding variable number of days to a date column

[rocky84]

Hello

Hoping for some help here on Power BI.

I have a master data table with data from multiple different periods combined (i.e. data for May month end, June month end, July month end etc.). My data tells me for each transaction the number of outstanding days on the trade until maturity, but it doesnt tell me the exact maturity date, hence I'm trying unsuccessfully to work this out. I can do it in excel and load it that way, but would rather do it in Power BI itself.

i.e. Period = 31/07/2022 (in date format & given in the data)

Outstanding Maturity = 89 (in numerical format & given in the data)

Maturity date = 28/10/2022 (required date format & NOT given in the data, but would like to derive from 31/07/2022 + 89 days)

Can anyone help me out? After this I would then like to group all my data by the new maturity date by months + year

any help much appreciated 🙂

[amitchandak · Accepted solution]

@rocky84 , if want to add days to date then you can simply add both, but date should have date data type 

[period] + [outstanding date]

for rest use date as dateadd

Date as Dateadd - Decoding Date and Calendar 5-5 - Power BI Turning 5 Celebration Series
https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power...

[vanessafvg · Accepted solution]

 DATEADD ( 'Date'[Date], -1, MONTH )

maturity date =

VAR noofdays = 89

VAR result =

    DATEADD ( 'Calendar'[Date], noofdays, DAY )

RETURN

    result

[amitchandak · Accepted solution]

@rocky84 , if want to add days to date then you can simply add both, but date should have date data type 

[period] + [outstanding date]

for rest use date as dateadd

Date as Dateadd - Decoding Date and Calendar 5-5 - Power BI Turning 5 Celebration Series
https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power...

[rocky84]

Thankyou sir. Always so helpful 😁