Offset Column in Date table

[Tidous972]

Hi everyone,

Is there a way to add an OffsetMonth column to an existing date table.

Thanks.

[jdbuchanan71 · Accepted solution]

Sure, add a new column and use this DAX.

OffsetMonth = DATEDIFF ( TODAY(), [Date], MONTH )