Forum Discussion
Solved
Create monthly value from Repeat amount
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!
Here I found the answer to my problem. Thanks
2 Replies
Here I found the answer to my problem. Thanks
Hello cmotta,
As far as I understand, you want to use native visuals such as table.
If so, please move your topic/question to this Power BI community.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
