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

     

     

     

     

tamerj1's avatar
tamerj1
Community Champion
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