Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you so much!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |