Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated column making reference to another row

Hello i need help with the next issue: I need to calculate the difference between 2 dates in the subsequent row if two conditions are achieved the number one is the column [Evento] = "BAJA-DEFINITIVA...
Need Help
Tips and Tricks
Tutorial Requests
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

HI Anonymous 

 

Sure, try something like this.

Column = 
IF( 
    'Table'[Evento] = "BAJA - DEFINITIVA", 
    VAR __date = 'Table'[Fecha del evento] 
    VAR __nextDate =
        CALCULATE(
            MIN( 'Table'[Fecha del evento]  ),
            ALLEXCEPT( 'Table', 'Table'[Plaza Unica] ),
            'Table'[Fecha del evento] > __date
        )
    RETURN 
    IF( NOT ISBLANK( __nextDate ), __nextDate - __date )
)

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.