Forum Discussion
Helper IProblem with repeat columns from thursday to wednesday
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
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
Helper IAnonymous Thanks for your recommendation, but it didn't work for me
Now it looks like this:
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