Problem with repeat columns from thursday to wednesday

[sebastianqc]

Hello , i have a problem:

Data 452.66 is not repeated like the previous data

I need the data to be repeated from Thursday to Wednesday and in the field of the first image it takes the value of the previous

Thursday

Please help me 

Thanks 
Sebastián

[v-shex-msft]

HI @sebastianqc,

It seems like your source data records contain exception rows that break 'continue' status and you want to format these exception records with the next records to fix this issue, right?

If this is a case, you can refer to the following calculated column: 

Formatted =
VAR _prev =
    LOOKUPVALUE ( T2[Value], T2[Index], [Index] - 1 )
VAR _next =
    LOOKUPVALUE ( T2[Value], T2[Index], [Index] + 1 )
VAR _status =
    IF ( [Value] = _prev || [Value] = _next, 1, 0 )
RETURN
    IF ( _status <> 1, _prev, [Value] )

Notice: this formula requires an index field, if your table contains a unique value field(number,date type), you can use it to replace

[Index] part.

Regards,

Xiaoxin Sheng

[sebastianqc]

@v-shex-msft  Thanks for your recommendation, but it didn't work for me

Now it looks like this:

[v-shex-msft · Accepted solution]

HI @sebastianqc,

So you mean to use the next value to replace the current one? If this is a case, you can modify the formula to use 'next value' to replace 'previous':

Formatted =
VAR _prev =
    LOOKUPVALUE ( T2[Value], T2[Index], [Index] - 1 )
VAR _next =
    LOOKUPVALUE ( T2[Value], T2[Index], [Index] + 1 )
VAR _status =
    IF ( [Value] = _prev || [Value] = _next, 1, 0 )
RETURN
    IF ( _status <> 1, _next , [Value] )

Regards,

Xiaoxin Sheng

[sebastianqc]

I copy the images from my problem and DAX

Problem