Forum Discussion
reference Previous row using measures.
Hi Anonymous
Can you create data samples, one with data set that you are working on, and second with the desired outcome.
Mariusz
- Anonymous7 years agoNot applicable
Group ID | Output
A101 | A101
A101 |
A102 | A102
A102 |
A102 |
A103 | A103
A101 | A101
- Mariusz7 years agoCommunity Champion
Hi Anonymous
I'm very sorry but its very hard to understand you requirement, are you looking to return distinct Values?Is your output to be presented in a visual or ist just a table?
Are you going to use as a part of calculation?
Best Regards,
Mariusz- Anonymous7 years agoNot applicable
i need use this in table visual.
Requirement is not to calculate distinct values, it is like you have to check current row and previous row if both matching then replace id with blank.
Id |Name|
1 | abc
2 | pqr
1 | abc
for above example output should be same as input there is no consecutive same values.
take another example
Id |Name|
1 | abc
1 | abc
2 | abc
output is
Id |Name|
1 | abc
| abc
2 | abc
here we are replacing second row's id values with blank.