Create monthly value from Repeat amount

[cmotta]

 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!

[v-viig]

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

pbicvsupport@microsoft.com

[cmotta · Accepted solution]

https://community.powerbi.com/t5/Desktop/How-to-add-rows-to-a-new-custom-table-based-on-values-in-ot...

Here I found the answer to my problem. Thanks