Forum Discussion

Chris_McD's avatar
Chris_McD
Regular Visitor
9 years ago
Solved

Delta Values from Previous Day Using Multiple Columns

Hello,   I have searched delta values for previous days but found an answer yet.   I am looking to produce dynamic delta values for specific items in tanks. The desired column is in blue below (o...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    So... I can't see why there would be a ciruclar dependency error, but my expression isn't QUITE correct either, please update, and maybe do a "plz work, plz work, plz work" dance :)

    VOLUME_DELTA =

    VAR Yesterday = MyTable[StartTime] - 1

    VAR MyMaterial = MyTable[Material Number]

    VAR MyElement = MyTable[Element]

    RETURN
        MyTable[Volume] -

        CALCULATE(VALUES(MyTable[Volume]),
                FILTER(ALL(MyTable),
                            MyTable[StartTime] = Yesterday &&

                            MyTable[Material Number] = MyMaterial &&

                            MyTable[Element] = MyElement
                )

         )

Chris_McD's avatar
Chris_McD
Regular Visitor
9 years ago

There was a circular dependency error when I put 'VOLUME_DELTA = ' at the beginning of the formula you sent to me. Please let me know if there is a step that I am missing or something else that I need to do with my data to rememdy this challenge:

 

 

VOLUME_DELTA =

VAR Yesterday = MyTable[StartTime] - 1

VAR MyMaterial = MyTable[Material Number]

VAR MyElement = MyTable[Element]

RETURN
    VALUES(MyTable[Volume]) -

    CALCULATE(VALUES(MyTable[Volume]),
            FILTER(MyTable,
                        MyTable[StartTime] = Yesterday &&

                        MyTable[Material Number] = MyMaterial &&

                        MyTable[Element] = MyElement
            )

     )

 

Thank you,

 

Chris

  • Chris_McD's avatar
    Chris_McD
    Regular Visitor
    9 years ago

    The other calculated columns that were added have now been removed and the circular dependency is still registering as the error.

     

    I appreciate your help.

     

    Chris

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      So... I can't see why there would be a ciruclar dependency error, but my expression isn't QUITE correct either, please update, and maybe do a "plz work, plz work, plz work" dance :)

      VOLUME_DELTA =

      VAR Yesterday = MyTable[StartTime] - 1

      VAR MyMaterial = MyTable[Material Number]

      VAR MyElement = MyTable[Element]

      RETURN
          MyTable[Volume] -

          CALCULATE(VALUES(MyTable[Volume]),
                  FILTER(ALL(MyTable),
                              MyTable[StartTime] = Yesterday &&

                              MyTable[Material Number] = MyMaterial &&

                              MyTable[Element] = MyElement
                  )

           )

      • Chris_McD's avatar
        Chris_McD
        Regular Visitor
        9 years ago

        This newer version worked.

         

        My dance came after.

         

        Thanks for the help.

         

        Chris