Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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     ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
7 years ago

 I have below SSRS logic

 IIF(Previous(Fields!name.Value) = Fields!name.Value,"",Fields!name.Value )

 

I want to implement it in Power BI.

Note: My source is Azure Analysis Services so I can not create index column

 

e.g

Name  output

A       

A        

B            B

C            C

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Output = IF(CALCULATE(COUNT(Table1[Source]),FILTER(Table1,Table1[Source]=EARLIER(Table1[Source])))>1,"",Table1[Source])

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I want measure not calculated column as my source is AAS. it won't allow creation of new calculated column