Forum Discussion

eddEdwards's avatar
eddEdwards
Frequent Visitor
3 years ago

Amount becomes the beginning

Hi, I am stuck and need help in solving the problem....How can I make the amount to start at the beginng?

Need Help

4 Replies

  • danextian's avatar
    danextian
    Super User
    3 years ago

    Hi eddEdwards ,

    Assuming that beginning is the cumulative amount of all transactions before the current date and you're using a separate dates table. Formula should be something like:

    =
CALCULATE (
    [Net],
    FILTER ( ALL ( DatesTable ), DatesTable[Date] < MAX ( DatesTable[Date] ) )
)
    • eddEdwards's avatar
      eddEdwards
      Frequent Visitor
      3 years ago

      Hi, Thanks for your quick reply..Yes BalBeginning is the Total amount of transactions which should start at the next quarter and the Continues...I am using the same date table...I Try to use your Dax but I get..ACircular dependency was detected

      CALCULATE (
    [Net],
    FILTER ( ALL ( DatesTable ), DatesTable[Date] < MAX ( DatesTable[Date] ) )