Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I am stuck and need help in solving the problem....How can I make the amount to start at the beginng?
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] ) )
)
Proud to be a Super User!
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] ) )
please post a screenshot of the error
Proud to be a Super User!
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
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |