Forum Discussion
eddEdwards
3 years agoFrequent Visitor
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?
eddEdwards
3 years agoFrequent Visitor
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] ) )
danextian
3 years agoSuper User
please post a screenshot of the error
- eddEdwards3 years agoFrequent Visitor
I have managed to use your formular which is a light to my tunnel..but I get in different result..my main aim is to add the bal to the contrubution then the trnsaction continues on and on...Find the attached link on your email for assistance..thanks