Forum Discussion

NilR's avatar
NilR
Post Patron
2 years ago
Solved

Slicer Date Range between two columns (filter help)

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!

"Date"
"DAX help"
"DAX"
"FILTER"
"Help"
  • NilR's avatar
    NilR
    2 years ago

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

1 Reply

  • NilR's avatar
    NilR
    Post Patron
    2 years ago

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