Create summarize table with Dax

[ChoiJunghoon]

Hello. 
Could you help me ? I can't know that by using DAX. 

TabelA

Date	DayName	Weekend
2021/7/1	Fri
2021/7/2	Sat	Y
2021/7/3	Sun	Y
2021/7/4	Mon
2021/7/5	Tue
2021/7/6	Wed
2021/7/7	Thu
2021/7/8	Fri
2021/7/9	Sat	Y
2021/7/10	Sun	Y
2021/7/11	Mon

TableB

Category	Start	End	Exclude
A	2021/7/1	2021/7/5	Sun
B	2021/7/4	2021/7/11	Weekend

Resutl

Category	Date
A	2021/7/1
A	2021/7/2
A	2021/7/4
A	2021/7/5
B	2021/7/4
B	2021/7/5
B	2021/7/6
B	2021/7/7
B	2021/7/8
B	2021/7/11

[Jihwan_Kim]

Result Table =

SUMMARIZE (

FILTER (

CROSSJOIN (

TableB,

TableA

),

TableA[Date] >= TableB[Start]

&& TableA[Date] <= TableB[End]

&& TableA[DayName] <> TableB[Exclude]

&& TableA[Weekend] <> TableB[Exclude]

),

TableB[Category],

TableA[Date]

)

https://www.dropbox.com/s/z2v5zarcevs81z7/choiv2.pbix?dl=0 

[wdx223_Daniel · Accepted solution]

[ChoiJunghoon]

Thank you so much!!