Forum Discussion
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 ...
Hi,
This should typically be a calculated column formula. You may download my PBI file from here.
Hope this helps.
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?
Mine is a calculated column formula solution (not a measure solution).