didijaba
Well-known Member
- Joined
- Nov 26, 2006
- Messages
- 511
HI, I have nice DAX by Alberto Ferrari, but I do not know how to modify it so slicers can be applied? For example, I have table 1 with fields ID, NAME, CITY, TYPE, OPENING_DATE, CLOSING_DATE and I would like to apply CITY, TYPE slicers.
Code:
SUMX('Table1';
CALCULATE(
COUNTROWS (Calendar);
Calendar[Date] >= EARLIER('Table1'[OPENING_DATE]);
Calendar[Date] <=EARLIER('Table1'[CLOSING_DATE])
)
)
Last edited: