Forum Discussion

greco's avatar
greco
New Member
3 years ago
Solved

cashflow problem

Hey, 

So, im working on a project and we are having trouble trying to create a specific report. 
We are working on a cashflow report. The clients company (gov) recieves 4 payments monthly, on a random day of the month, but he realize payments everyday.
He want to be able to see a report that shows him on the columns only the 4 days that he recieve money. In the first line the amount of money recieved and in the following lines he wants to see the payments made of the last days. 
Example:
DAYS                4             12           19              27   
RECIEVED         5k           3k           10k           6k
COST                2k           5k            ...

But the point is, the cost have to get the interval of days since the last cash recieved. In day 12, he wants to see the costs of days 5 to 12. In day 19, the costs of days 13 to 19. 

Im stuck on this for days, so it would be incredible to have any solution for that.

OBS. 
I have 1 table w all my cashflow, but i also created 2 diff tables for each mov.

Need Help
  • greco's avatar
    greco
    3 years ago

    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.

4 Replies

    • greco's avatar
      greco
      New Member
      3 years ago

      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.