Create a End date column based on Created date column

[MikeHunt]

Hello everyone,

I have a Created date column in my Power BI data. Now, I need a formula that will create an End date column that filters per Code and shows the Created date value of next row if not balnk. Example shown below.

[Rohit11 · Accepted solution]

Try this ! 

End = MINX (

    FILTER (

        'Table',

        'Table'[Create] > EARLIER (   'Table'[Create]  )

            && 'Table'[Code] = EARLIER ( 'Table'[Code] )

    ),

     'Table'[Create]

)

Mark as ansered if it solved your problem .