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.
Hey,
Thanks for ur reply. I tried after seeing ur message, but stiil have a problem. I cant make it in a way that get the cummulative sum of each interval, i was able to do it only for last interval.
Im trying to think in a new way to do it, like creating a table that have two columns, all the payments we made and a date column. On the date column, the dax function have to get the original day of the payment and look up for the next day that we recieved cash, and change the date of the payment to that date. Idk if will works but tbh im getting a bit crazy about this.
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.