Forum Discussion
Solved
Offset Month Calculated Column
Hi, I have a column named 'Month' which just has the dates of the 1st day of each month (see below) The MAX month as you can see is Sep 2022. I would like to create a calculated col...
Try this calculated column in the table DimDate:
Offset Month = VAR vToday = TODAY () VAR vResult = DATEDIFF ( vToday, DimDate[Date], MONTH ) + 1 RETURN vResult
Try this calculated column in the table DimDate:
Offset Month =
VAR vToday =
TODAY ()
VAR vResult =
DATEDIFF ( vToday, DimDate[Date], MONTH ) + 1
RETURN
vResult
Perfect, thats exactly what I need!
Many thanks!