How to convert an excel formula to DAX language

[Anonymous]

Hello,

could I get some help on how to convert following Excel formala to Dax?

=IF(C2=C1;E1+1;1)

Here is a matrix table with the formula:

Any help is greatly appreciated!

Regards,
Stoyan

[ryan_mayu · Accepted solution]

@Anonymous 

maybe you can try this

1. add an index column in PQ

2. use DAX to create a column

Column = RANKX(FILTER('Table','Table'[surveykey]=EARLIER('Table'[surveykey])),'Table'[Index],,ASC)

[StefanoGrimaldi]

hey, theres not direct way to replicate a excel formula sinces DAX function different , its column, row based evaluation instead of a per cell evaluation as excel. 

what you can do its learn a little dax and them add a index column and write a dax that compare a row for column value with that same row index -1 (previus entrey) or any other column you could us as hitorical entry reference. 

[Anonymous]

is it EARLIER function that should be used?