Forum Discussion

Frequent Visitor

4 years ago

Solved

Offset Column in Date table

Hi everyone,

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

Thanks.

jdbuchanan71
4 years ago
Sure, add a new column and use this DAX.

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

1 Reply

jdbuchanan71
Super User
4 years ago
Sure, add a new column and use this DAX.

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