Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
In DAX, there's no order internally for records in table. You have to add an index column in your table.
PreviousText = CALCULATE(MAX(Table1[Text]),FILTER(Table1,Table1[Index]=EARLIER(Table1[Index])-1))
Regards,
In DAX, there's no order internally for records in table. You have to add an index column in your table.
PreviousText = CALCULATE(MAX(Table1[Text]),FILTER(Table1,Table1[Index]=EARLIER(Table1[Index])-1))
Regards,
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]))
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))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |