Forum Discussion

LadyPeshet's avatar
LadyPeshet
Frequent Visitor
3 years ago
Solved

Create End Date using Start Dates

Hello,   I have a table in Power BI like this:   ID START_DATE 1 06/24/2016 1 06/24/2017 1 06/24/2018 2 08/08/2017 2 08/08/2016 3 12/12/2015   I would like to create a calculate...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi LadyPeshet 
    Please try

    END_DATE =
MINX (
    FILTER (
        CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[ID] ) ),
        'Table'[START_DATE] > EARLIER ( 'Table'[START_DATE] )
    ),
    'Table'[START_DATE]
) - 1

     

     

     

     

amitchandak's avatar
amitchandak
Super User
3 years ago

LadyPeshet , Create a new column like

 

end date =

Var _min = Minx(filter( table, [ID] = earlier([ID]) && [Start Date] > earlier([Start Date]) ), [Start Date])

return

if(isblank(_min), blank(), _min-1)