Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
This is my Slicer
I need to figure out in this date range exist anywhere between these rows for each group#?
So I wanna say if
_Min_Date_Slicer is between Min(Inc_Start) and Max(Inc_Start)
__Max_Date_Slicer is between Min(Inc_End) and Max(Inc_End)
FILTER(
'Table', GROUP#=_GRP &&
_MIN_Date_Slicer >= MIN([INC_START]) && _MIN_Date_Slicer <= MAX([INC_START]) &&
_MAX_Date_Slicer >= MIN([INC_END]) && _MAX_Date_Slicer <= MAX([INC_END])
)
Can you help with this function? Thanks!
Solved! Go to Solution.
Found solution:
CALCULATE(SUMX(VALUES('TBL'[GROUP#]),1),
FILTER(
'Table', GROUP#=_GRP &&
(_MIN_Date_Slicer >= MIN([INC_START]) && _MIN_Date_Slicer <= MAX([INC_END])) ||
(_MAX_Date_Slicer >= MIN([INC_START]) && _MAX_Date_Slicer <= MAX([INC_END]))
)
)
Found solution:
CALCULATE(SUMX(VALUES('TBL'[GROUP#]),1),
FILTER(
'Table', GROUP#=_GRP &&
(_MIN_Date_Slicer >= MIN([INC_START]) && _MIN_Date_Slicer <= MAX([INC_END])) ||
(_MAX_Date_Slicer >= MIN([INC_START]) && _MAX_Date_Slicer <= MAX([INC_END]))
)
)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |