Fill with the value of the previous cell in DAX

[Syndicate_Admin]

Good afternoon.

I need to get the expected result in the Nevento column with DAX

The expected result is still the start date/time of each event.

The "whim of doing it with Dax is because of the volume of dtos (1,700,000 and going up).

I have tried to refer to the colu

[Icey · Accepted solution]

Hi @JECJ ,

Try to create a column like so:

Column =
VAR Most_Recent_Date_Without_Event =
    MAXX (
        FILTER (
            'Table',
            'Table'[Date] < EARLIER ( 'Table'[Date] )
                && 'Table'[Event] = BLANK ()
                && EARLIER ( 'Table'[Event] ) <> BLANK ()
        ),
        [Date]
    )
RETURN
    MINX (
        FILTER (
            'Table',
            'Table'[Date] > Most_Recent_Date_Without_Event
                && Most_Recent_Date_Without_Event <> BLANK ()
        ),
        [Date]
    )

Best Regards,

Icey

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

[Syndicate_Admin]

Perrrrrrfectoooo

Thanks a lot. Works.

Eres el fmou (f?" % master of universe)

A hug from Malaga

[Syndicate_Admin]

Can you include data in table format? (not an image)

[Singaravelu_R]

Hi, 

I am not sure what you are need exactly, based on excel you have show I have given result like below, if you need anyother things plesase reply,

Add calculated column 

Nevento = if('Table'[Evento]=1,'Table'[Date].[Date])

[Syndicate_Admin]

First of all thank you for the answer @Syndicate_Admin

What I intend is that you "drag" the first date time while the event is 1 consecutively. The moment you go to zero and go back to one, take back the first date/time of the next event.

Greetings