Slicer Date Range between two columns (filter help)

NilR — Fri, 15 Dec 2023 18:07:21 GMT

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!

Re: Slicer Date Range between two columns (filter help)

NilR — Fri, 15 Dec 2023 19:34:28 GMT

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]))
)
)

topic Re: Slicer Date Range between two columns (filter help) in DAX Commands and Tips

Slicer Date Range between two columns (filter help)

Re: Slicer Date Range between two columns (filter help)