Forum Discussion
cashflow problem
Hey. Thanks again, I will try to use DATESINPERIOD just for my knowledge cause by now, my solution worked.
I created a table w 4 fields, the first one is each transaction we made, the second is the date of each payment. The third one is a "boolean" field, that results in false if the value of the transaction is < 0.After doing this, i created my fourth field, that get all the transactions where the third field is equal to false and alter the date to the day of the next true on the field.
Then, DATESINPERIOD/DATESBETWEEN could be a solution. You take the maximum and the minimum value of your date calendar (which will be filter within the period selected) and calculate the sum. https://radacad.com/datesinperiod-vs-datesbetween-dax-time-intelligence-for-power-bi
Hey. Thanks again, I will try to use DATESINPERIOD just for my knowledge cause by now, my solution worked.
I created a table w 4 fields, the first one is each transaction we made, the second is the date of each payment. The third one is a "boolean" field, that results in false if the value of the transaction is < 0.
After doing this, i created my fourth field, that get all the transactions where the third field is equal to false and alter the date to the day of the next true on the field.