Hi,
I have an application database that is designed the following way: (I cannot change it)
| ID | TypeID | PropertyID | Date | Repeat Count | Amount |
| 1 | 1 | 1 | 2017-01-01 | 12 | 100 |
| 2 | 1 | 2 | 2017-01-01 | 1 | 35 |
| 3 | 1 | 1 | 2018-01-01 | 12 | 105 |
| 4 | 2 | 3 | 2017-01-05 | 1 | 500 |
| 1 | 1 | 1 | 2017-01-01 | 12 | 100 |
I need to be able to create a cash flow that can tell me by month, Property and type what the amount of that month is. I figured I need in a measure in a table that has all the months I need, but I am not sure how to do it.
Any help would be greatly appreciated it!
Thanks!
