Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Month number

Hello, I need to have in PowerBI a column which will display number of month in callendar. At this moment I have an Callendar table created by  CALENDAR = CALENDAR(DATE(2018.,1.,1),EOMONTH(Today()...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Anonymous 

    try like:

    NewColumn = 
    DATEDIFF([DATE], TODAY(), MONTH)
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Anonymous 

try like:

NewColumn = 
DATEDIFF([DATE], TODAY(), MONTH)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks it works. I needed only to add "-" before statement to achieve exactly what I want.

    Column = -(DATEDIFF(TODAY(), [DATE], MONTH))