Create a StartDate and EndDate column after value change

Hi,@adnane_k 

You can try the following methods.

1. Create a calculated column and use the if function to judge whether the value has changed.

Value = 
IF (
    'Table'[Old Value] = 'Table'[New Value],
    'Table'[Old Value],
    'Table'[New Value]
)

   2. Create a calculation column to calculate the Start Date and End Date.

Start Date = 
IF ( 'Table'[Old Value] <> 'Table'[New Value], [Date], BLANK () )

End Date = 
MINX (
    FILTER ( 'Table', 'Table'[Old Value] = EARLIER ( 'Table'[Value] ) ),
    [Start Date] - 1
)

  3. About tracking the COUNT of [values] each day, see if I understand correctly.

Count =
CALCULATE (
    COUNT ( 'Table'[Value] ),
    FILTER ( ALL ( 'Table' ), 'Table'[Start Date] = MAX ( 'Table'[Start Date] ) )
)

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more.