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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

This should typically be a calculated column formula.  You may download my PBI file from here.

Hope this helps.

 

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).