Forum Discussion
how to Reference previous row in same column
I have one column like this City A A B C C and my requirement is if previous(city)=city then 0 else city and first one should be 0 So output city Column A 0 A ...
Output = IF(CALCULATE(COUNT(Table1[Source]),FILTER(Table1,Table1[Source]=EARLIER(Table1[Source])))>1,"",Table1[Source])
I want measure not calculated column as my source is AAS. it won't allow creation of new calculated column