Forum Discussion
reference Previous row using measures.
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?
Mariusz
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
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.