Forum Discussion
Solved
Create summarize table with Dax
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 ...
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]
)