Intersect ( set1, set2 [,ALL] )
A set to intersect with set2.
A set to intersect with set1.
The optional ALL keyword retains matching duplicates in set1 and set2.
select
members(measure) on 0,
intersect(members(Calendar), children(Calendar.[ALL].[2021])) on 1
from [Online Store] ;
| sales amount | sales quantity | cash back | |
| Q1 | 4320 | 432 | 0 |
| Q2 | 4320 | 432 | 0 |
| Q3 | 22088 | 20539 | 0 |
| Q4 | 21231 | 22317 | 0 |