Forum Discussion
Calculated column that returns row sequences
Hello,
I need help creating the Dispense # column below:
If it helps this is the jmp script code snipet:
If( :ValueName == "Dispense Weight Chec", If( Lag( :ValueName ) != "Dispense Weight Chec", 1, Lag( :Dispense # ) + 1 ) )
I figured I could use EARLIER() but it gives me an error.
3 Replies
MorePowerBI , if in row 6 is wrong, You have to just write condition
lol yeah I know it's wrong, that's why I'm here!
Not sure how to write the condition to get the column I want.
Still looking to see if anyone can help me with this.
