Forum Discussion
reference Previous row using measures.
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.
Hi Anonymous
Sorry but I don't think this can be achieved in power bi at the moment.
When adding column or columns to a visual it will perform a group by ( select a distinct combination of column values ) and measures can only aggregate so the below outcome is impasibe.
Id |Name|
1 | abc
| abc
2 | abc
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
