How to find reverse month

[Anonymous]

Hi 

I have one scenario 

I want to calculate Month coloumn , condition is that higehst month should be 0 and the preceeding back month should be minus by 1.
Please help me to solve this issue.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

It is for creating a new column.

Month expected result CC =
VAR _currentdate = Data[Date]
VAR _maxdate =
    MAX ( Data[Date] )
VAR _mindate =
    MIN ( Data[Date] )
VAR _monthlytable =
    SUMMARIZE (
        ADDCOLUMNS (
            CALENDAR ( _mindate, _maxdate ),
            "@endofmonth", EOMONTH ( [Date], 0 )
        ),
        [@endofmonth]
    )
RETURN
    -1
        * (
            COUNTROWS ( FILTER ( _monthlytable, [@endofmonth] >= _currentdate ) ) - 1
        )

[tamerj1]

Hi @Anonymous 
You acan use

Month =
RANKX ( 'Table', 'Table'[Date],, DESC, Dense ) - 1