grab a previous cell using an Index. The index is based off a unique order number.

[Anonymous]

I have an index for each order number as there is multiple entries for each. I want to grab the previous rows WCode.

This the DAX statement that I have been trying to use.

Test = VAR a = CALCULATE ( FIRSTNONBLANK('Gip700 Summary'[WCode]) FILTER( 'Gip700 Summary', 'Gip700 Summary'[Index]= EARLIER('Gip700 Summary'[Index]) && 'Gip700 Summary'[Order Number] = EARLIER('Gip700 Summary'[Order Number])) ) RETURN a

[Anonymous · Accepted solution]

Heres the solution to this.

Test = IF('Gip700 Summary'[Order Number]='Gip700 Summary'[Order Number],LOOKUPVALUE('Gip700 Summary'[WCode],'Gip700 Summary'[Index],'Gip700 Summary'[Index]+1))

[danno]

Hi, you could use powerquery to replace zeroes with null and then fill down the column, would that work?  You could order data in by index first 

Dan

[Anonymous]

Test = VAR a = CALCULATE ( FIRSTNONBLANK('Gip700 Summary'[WCode]) FILTER( 'Gip700 Summary', 'Gip700 Summary'[Index]= EARLIER('Gip700 Summary'[Index]) && 'Gip700 Summary'[Order Number] = EARLIER('Gip700 Summary'[Order Number])) ) RETURN a

 This the DAX that I have been trying to work with.

[Anonymous]

I wouldn't be able to do that as zero is a code that I would need for a seperate column after I can get the test column completed

[danno]

You could duplicate the column if you need the zeroes