Forum Discussion
Solved
Calculate end date
Hello, I'm having trouble calculating the client's end date of a "phase". I'm following this logic: the phase's end date is the initial date of next one initial ...
Hi yan23,
You could create a index column in Query Editor first.
Then you could create the calculated column with the DAX formula below.
Column = VAR a = CALCULATE ( MIN ( 'Sheet'[Index] ), FILTER ( ALL ( 'Sheet' ), 'Sheet'[Index] > EARLIER ( Sheet[Index] ) ) ) RETURN CALCULATE ( MAX ( 'Sheet'[initial] ), FILTER ( 'Sheet', 'Sheet'[Index] = a ) )Here is the result output.
If you need additional help, please share some data sample and your desired output.
Best Regards,
Cherry
Hi yan23,
You could create a index column in Query Editor first.
Then you could create the calculated column with the DAX formula below.
Column =
VAR a =
CALCULATE (
MIN ( 'Sheet'[Index] ),
FILTER ( ALL ( 'Sheet' ), 'Sheet'[Index] > EARLIER ( Sheet[Index] ) )
)
RETURN
CALCULATE (
MAX ( 'Sheet'[initial] ),
FILTER ( 'Sheet', 'Sheet'[Index] = a )
)
Here is the result output.
If you need additional help, please share some data sample and your desired output.
Best Regards,
Cherry
thank you it worked!:smileyhappy:
