Forum Discussion

MikeHunt's avatar
MikeHunt
Regular Visitor
2 years ago
Solved

Create a End date column based on Created date column

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 ...
Need Help
Show and Tell
  • Rohit11's avatar
    Rohit11
    2 years ago

    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 . 

     

Rohit11's avatar
Rohit11
Resolver II
2 years ago

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 .