topic Re: Create monthly value from Repeat amount in Custom Visuals Development Discussion

Create monthly value from Repeat amount

cmotta — Wed, 13 Sep 2017 17:08:44 GMT

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!

Re: Create monthly value from Repeat amount

v-viig — Thu, 14 Sep 2017 08:04:56 GMT

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

Re: Create monthly value from Repeat amount

cmotta — Tue, 19 Sep 2017 13:34:19 GMT

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

Here I found the answer to my problem. Thanks