Forum Discussion

swisdom's avatar
swisdom
Icon for Helper I rankHelper I
4 years ago

Calculation IF a value appears in earlier rows

I have a set of data including RMAs with various dates. I would like to create a measure which calculates if a particular Serial Number has been returned multiple times, and IF it does, to calculate ...
Need Help
swisdom's avatar
swisdom
Icon for Helper I rankHelper I
4 years ago

Hello thank you for your response!

So your method looks great, however when I try to apply it to my actual dataset (not the test dataset) I get this error: "Circular dependency was detected"

(I split up the code a bit just for myself so I could read it easier)

 

Any ideas why I would get that error?

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Mine is a calculated column formula solution (not a measure solution).