how to Reference previous row in same column

Question

I have one column like this&nbsp;CityAABCC&nbsp;and my requirement is if previous(city)=city then 0 else city and first one should be&nbsp; 0&nbsp;So output&nbsp;city&nbsp; &nbsp; &nbsp;ColumnA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0

pattemmanohar · Answer

Anonymous&nbsp; Please add an Index column in "Power Query Editor" and then add a new column in Data Pane as below
&nbsp;
CheckPrev = 
VAR _PrevRow = LOOKUPVALUE(Test242PrevRow[City],Test242PrevRow[Index],Test242PrevRow[Index]-1)
RETURN IF(Test242PrevRow[City]=_PrevRow || Test242PrevRow[Index] = 1,"0",Test242PrevRow[City])

&nbsp;

anonymous · Answer

Is it possible without adding column?

anonymous · Answer

and in real time scenario i don't know how many rows are there so please provide dynamic solution

pattemmanohar · Answer

Anonymous&nbsp; Don't think it's possible without having any supporting field to lookup on to retrieve next or previous row logic.&nbsp;
&nbsp;
It's a dynamic solution and it will work irrespective of number of rows in your table....

anonymous · Answer

&nbsp;I have below SSRS logic&nbsp;IIF(Previous(Fields!name.Value) = Fields!name.Value,"",Fields!name.Value )&nbsp;I want to implement it in Power BI.Note: My source is Azure Analysis Services so I can not create index column&nbsp;e.gName&nbsp; outputA&nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C

Forum Discussion

how to Reference previous row in same column

8 Replies

Related content

Referring Same Column - Previous Value

UDF with variable table reference and fixed column reference

DAXUDF Reference a column

Reference Previous Value in adjacent column

Using column value as column reference