cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Taranggupta
New Member

How to get previous row value for text column.

Hi,

 

I would like to get the previous row value for a text column using DAX.

 

Example: Text_column

                    A

                    B

                    C

 

Expected Output: 

             Text_column, Previous_value

                    A                    NULL

                    B                       A

                    C                       B

 

Please let me know incase of any clarification.

 

Thanks in Advance.

1 ACCEPTED SOLUTION
v-sihou-msft
Microsoft
Microsoft

@Taranggupta

 

In DAX, there's no order internally for records in table. You have to add an index column in your table. 

 

22.PNG

 

PreviousText = CALCULATE(MAX(Table1[Text]),FILTER(Table1,Table1[Index]=EARLIER(Table1[Index])-1))

234.PNG

 

Regards,

 

 

View solution in original post

3 REPLIES 3
v-sihou-msft
Microsoft
Microsoft

@Taranggupta

 

In DAX, there's no order internally for records in table. You have to add an index column in your table. 

 

22.PNG

 

PreviousText = CALCULATE(MAX(Table1[Text]),FILTER(Table1,Table1[Index]=EARLIER(Table1[Index])-1))

234.PNG

 

Regards,

 

 

View solution in original post

Hi, 

 

@v-sihou-msft I am trying to replicate this and have added the index column, but getting a row context error from the EARLIER function onwards:

 

previous index = CALCULATE(MAX('Curso Académico'[Curso]);FILTER('Curso Académico';'Curso Académico'[Index]=EARLIER('Curso Académico'[Index]))


Row context error.PNG

 

Any ideas what I'm doing wrong?

 

Thanks!

 

...

is the -1 missing at the end? 

 

previous index = CALCULATE(MAX('Curso Académico'[Curso]);FILTER('Curso Académico';'Curso Académico'[Index]=EARLIER('Curso Académico'[Index])-1))

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors