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 | |
| 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 |
3 Replies
Thank you so much!!
- 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])
