Subtract a column in table2 numofmonths from a date field in table1

[mloc1990]

Hi,

I have Table1 with [authdate] I'm trying to subtract table2[NumofMonths] from this date to get a new date. From the solutions I've found the subtraction of the months is always a static number. How would I subtract the column  NumofMonths to get the new authdate?

Thanks

[v-yuta-msft]

@mloc1990 ,

You can create a calculate column using DAX below:

authdate = Table[CurrentNum] - Table[NumofMonths]

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mloc1990]

@v-yuta-msft 

I've tried this but it only takes a number of days from the original date instead of months.

[v-yuta-msft · Accepted solution]

@mloc1990 ,

You can modify calculate column as below:

Result =
DATEDIFF ( Table[NumofMonths], Table[CurrentNum], MONTH )

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mloc1990]

Thanks @v-yuta-msft  this works!