Add a column of "days" to a set date and return a future date

[justincordasco]

I have a column of dates and a colum of "Avg days to collect". I want to calculate the expected date of collection by adding the number of days the dates in the first column. Suggestions? 

[Anonymous]

If your existing date field is recognised as date type you can either add it as a column or create a measure.

Column:

Column = 'Table'[date] + 'Table'[add date]

Measure:

Measure = sumx('Table';'Table'[date] + 'Table'[add date])

Kind regards
Joren Venema

Data & Analytics Consulant
If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily.

[justincordasco]

Thanks, but what if they each column is from a different table? I've tried adding them together, but it keeps defaulting the date to a Count of Date. 

[Anonymous]

Assuming you have a relation between the 2 tables you can use the related() function.

Try the following:

Measure = sumx('Table';'Table'[Date] +RELATED('Table (2)'[add date]))

Kind regards
Joren Venema

Data & Analytics Consulant
If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily.

[justincordasco]

Thank you. Still having an issue. I have a relationship between the tables, but for some reason I am getting an error that they are not related. See screenshots below. One of each table and one of the error. They are both related by the client ID. 

[Anonymous]

Would you mind sharing the report with a limited amount of data?