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)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 

please try

Number of Month =
RANKX ( 'CALENDAR', FORMAT ( 'CALENDAR'[Date], "YYYYMM" ),, Asc, DENSE ) - 1