Using slicers to populate or enter data into tables

[mrothschild]

Very new to PowerBI.

Here are links to .PBIX and .XLS table, respectively for reference.

https://www.dropbox.com/s/rbjoqspdjdmtquq/Power%20BI%20Forum%20Sample.pbix?dl=0

https://www.dropbox.com/s/5vobo0j9b1j72hk/Slicer%20Inputs.xlsx?dl=0

I have a dashboard with one chiclet slicer, and 5 slider slicers.

• Project Number [chiclet slicer]
• Acquisition Cost
• Revenue Yield
• Start Month
• Start Year
• Duration (mos)

From these inputs, I'd like to generate a new table that looks loosely as follows.  Then when I select a different Project Number, I'd like it to add the different inputs to the Table below.  On a related note, is it possible to change the "Project Number" slicer to a "Project Name" from a dropdown list?

Project Number	Acquisition Cost	Revenue Yield	Start Month	Start Year	Duration		Count	Calendar Date	Revenue
2	50	1%	5	2019	60		1	5/31/2019	0.5
2	50	1%	5	2019	60		2	6/30/2019	0.5
2	50	1%	5	2019	60		3	7/31/2019	0.5
2	50	1%	5	2019	60		4	8/31/2019	0.5
2	50	1%	5	2019	60		5	9/30/2019	0.5
2	50	1%	5	2019	60		6	10/31/2019	0.5
2	50	1%	5	2019	60		7	11/30/2019	0.5
2	50	1%	5	2019	60		8	12/31/2019	0.5
2	50	1%	5	2019	60		9	1/31/2020	0.5
2	50	1%	5	2019	60		10	2/29/2020	0.5
2	50	1%	5	2019	60		11	3/31/2020	0.5
2	50	1%	5	2019	60		12	4/30/2020	0.5
2	50	1%	5	2019	60		13	5/31/2020	0.5
2	50	1%	5	2019	60		14	6/30/2020	0.5
2	50	1%	5	2019	60		15	7/31/2020	0.5
2	50	1%	5	2019	60		16	8/31/2020	0.5
2	50	1%	5	2019	60		17	9/30/2020	0.5
2	50	1%	5	2019	60		18	10/31/2020	0.5
2	50	1%	5	2019	60		19	11/30/2020	0.5
2	50	1%	5	2019	60		20	12/31/2020	0.5
2	50	1%	5	2019	60		21	1/31/2021	0.5
2	50	1%	5	2019	60		22	2/28/2021	0.5
2	50	1%	5	2019	60		23	3/31/2021	0.5
2	50	1%	5	2019	60		24	4/30/2021	0.5
2	50	1%	5	2019	60		25	5/31/2021	0.5
2	50	1%	5	2019	60		26	6/30/2021	0.5
2	50	1%	5	2019	60		27	7/31/2021	0.5
2	50	1%	5	2019	60		28	8/31/2021	0.5
2	50	1%	5	2019	60		29	9/30/2021	0.5
2	50	1%	5	2019	60		30	10/31/2021	0.5
2	50	1%	5	2019	60		31	11/30/2021	0.5
2	50	1%	5	2019	60		32	12/31/2021	0.5
2	50	1%	5	2019	60		33	1/31/2022	0.5
2	50	1%	5	2019	60		34	2/28/2022	0.5
2	50	1%	5	2019	60		35	3/31/2022	0.5
2	50	1%	5	2019	60		36	4/30/2022	0.5
2	50	1%	5	2019	60		37	5/31/2022	0.5
2	50	1%	5	2019	60		38	6/30/2022	0.5
2	50	1%	5	2019	60		39	7/31/2022	0.5
2	50	1%	5	2019	60		40	8/31/2022	0.5
2	50	1%	5	2019	60		41	9/30/2022	0.5
2	50	1%	5	2019	60		42	10/31/2022	0.5
2	50	1%	5	2019	60		43	11/30/2022	0.5
2	50	1%	5	2019	60		44	12/31/2022	0.5
2	50	1%	5	2019	60		45	1/31/2023	0.5
2	50	1%	5	2019	60		46	2/28/2023	0.5
2	50	1%	5	2019	60		47	3/31/2023	0.5
2	50	1%	5	2019	60		48	4/30/2023	0.5
2	50	1%	5	2019	60		49	5/31/2023	0.5
2	50	1%	5	2019	60		50	6/30/2023	0.5
2	50	1%	5	2019	60		51	7/31/2023	0.5
2	50	1%	5	2019	60		52	8/31/2023	0.5
2	50	1%	5	2019	60		53	9/30/2023	0.5
2	50	1%	5	2019	60		54	10/31/2023	0.5
2	50	1%	5	2019	60		55	11/30/2023	0.5
2	50	1%	5	2019	60		56	12/31/2023	0.5
2	50	1%	5	2019	60		57	1/31/2024	0.5
2	50	1%	5	2019	60		58	2/29/2024	0.5
2	50	1%	5	2019	60		59	3/31/2024	0.5
2	50	1%	5	2019	60		60	4/30/2024	0.5
							end

[v-piga-msft]

Hi @mrothschild,

I have a little confused about your scenario. 

As I understand, do you want to get the dropdown slicer like below?

In addition, it seems that you want to get the output you post.

If it is, please refer to the Page 4 in my attachment.

If you still need help, please describe the logic which could get your desired output in more details so that we could help further on it.

Best  Regards,

Cherry

[mrothschild]

Thank you, and apologies for the delayed response, I was traveling yesterday. 

Your Page 4 is helpful and a great start, but not quite the solution.  

The calendar month in your Page 4 starts at 10/31/18, and I want it to start, per the slide at May 2019 - I'll add in EOMONTH( ) to resolve the day.  

In the table in my original post, I showed monthly revenue of 0.5, which was the 1% [Revenue Yield] Value in your slider * the 50 of [Acquisition Cost] value.

Lastly, what I'd like is to be able to add project, say 37, and append all the data shown on Page 4 to either an existing table, or create a new table from it that I can then use for visuals on Page 2.

Thanks!