Slice creation for new tabel

[Anchor_Appadmin]

I have two tables like below

1. Daily updating table
   

2. Only for report - ( editing the same row)
   

I want to create a slice table C with the date of table A based on table B criteria

like this

Any one please suggest me a solution for this

[JuneCorpuz]

Hello-

I’m not sure if I got it correctly but based on your screenshots. You want to filter the data in Table A based on the columns in Table B. If yes, please test the formula below. But I haven’t tested it in the app editor. Feel free to give feedback in case you encountered any errors.

AND(
	[Date] >= 
	ANY(
		SELECT(
			Table B[From],
			TRUE
		)
	),
	
	[Date] <=
	ANY(
		SELECT(
			Table B[To],
			TRUE
		)
	),
	
	[Customer] = 
	ANY(
		SELECT(
			Table B[Customer],
			TRUE
		)
	)
)