Is it possible to carry one last value in time (T2) over to previous times? In Tableau I would use LOD "FIXED" expression..
I already tried all the PARENT filters WITH/WITHOUT EXCEPT.. Nothing works..
Input:
| Time | Value |
| -------- | -------------- |
| T-1 | 7 |
| T0 | 8 |
| T1 | 9 |
| T2 | 10 |
Wanted output:
| Time | Value | Result |
| -------- | -------------- | ------ |
| T-1 | 7 | 10 |
| T0 | 8 | 10 |
| T1 | 9 | 10 |
| T2 | 10 | 10 |
Best answer by Jan Kos
View original