Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
4 years ago
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...
Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    ArchStanton,

     

    Try this calculated column in the table DimDate:

     

    Offset Month = 
VAR vToday =
    TODAY ()
VAR vResult =
    DATEDIFF ( vToday, DimDate[Date], MONTH ) + 1
RETURN
    vResult

     

     

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
4 years ago

ArchStanton,

 

Try this calculated column in the table DimDate:

 

Offset Month = 
VAR vToday =
    TODAY ()
VAR vResult =
    DATEDIFF ( vToday, DimDate[Date], MONTH ) + 1
RETURN
    vResult

 

 

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
4 years ago

Perfect, thats exactly what I need!

Many thanks!