Insert rows based on slicer value in calculated table

[khizerk]

Hi,

I have created the following calculated table. Some sample data is below:

AccountCodeInvestmentCodeTransactionDateEndValLCYOpenValLCYTWR Open Bal LCYTWR End Bal LCYCashflowsPeriod TWR

35R5F5B	XNYS:SYK	26/03/2020 12:00:00 AM			0	254391.35	254391.35	1
35R5F5B	XNYS:SYK	29/04/2022 12:00:00 AM	386016	396880	396880	386016	-945.2	0.975008062890546
35R5F5B	XNYS:SYK	31/01/2022 12:00:00 AM	396880		254391.35	396880	-945.2	1.56383147461578
35R5F5B	XNYS:SYK	29/10/2021 12:00:00 AM			254391.35	254391.35	-856.8	1.00336803904693
35R5F5B	XNYS:SYK	30/07/2021 12:00:00 AM			254391.35	254391.35	-856.8	1.00336803904693
35R5F5B	XNYS:SYK	30/04/2021 12:00:00 AM			254391.35	254391.35	-856.8	1.00336803904693
35R5F5B	XNYS:SYK	29/01/2021 12:00:00 AM			254391.35	254391.35	-856.8	1.00336803904693
35R5F5B	XNYS:SYK	30/10/2020 12:00:00 AM			254391.35	254391.35	-782	1.00307400389203
35R5F5B	XNYS:SYK	31/07/2020 12:00:00 AM			254391.35	254391.35	-782	1.00307400389203
35R5F5B	XNYS:SYK	30/04/2020 12:00:00 AM			254391.35	254391.35	-782	1.00307400389203

I would like to add rows for each distinct InvestmentCode in the parent table (Txns) with the transactiondate set to the date selected in a slicer. 

For example, if the user selected 31/07/2020 as the date on the slicer, no row would need to be added for InvestmentCode XNYS:SYK since it is already there, but would need to be added InvestmentCode ARCA:BRKB since the row is not there for that date. Wondering how to achieve this?

[v-rongtiep-msft]

Hi @khizerk ,

 Why did you add that row?What kind of results do you want? Does InvestmentCode ARCA:BRKB appear in the table? Could you please provide a screenshot with your desired output?

How to Get Your Question Answered Quickly  

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.