Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Apply Two Date Filters to a Table Visual

Hi,   I am looking for some help where i would like to apply 2 date filters on a table visual. I would like the results in the table to be filtered if:-   Design Date is >= 01 Jan 2022 and <= 31 ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Try a new measure. Only measure can use slicer value. Calculated column can not use the same

     

    //Date1 is independent Date table
    new measure =
    var _max = maxx(allselected(Date1),Date1[Date])
    var _min = Minx(allselected(Date1),Date1[Date])
    Var _cnt =
    countrows(filter( 'Table', ( 'Table'[Design Date] >=_min && 'Table'[Design Date] <=_max) || ( 'Table'[Ordered Date] >=_min && 'Table'[Ordered Date] <=_max) ) )

     

    return

    if(isblank(_cnt) , "No", "Yes")

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Try a new measure. Only measure can use slicer value. Calculated column can not use the same

 

//Date1 is independent Date table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = Minx(allselected(Date1),Date1[Date])
Var _cnt =
countrows(filter( 'Table', ( 'Table'[Design Date] >=_min && 'Table'[Design Date] <=_max) || ( 'Table'[Ordered Date] >=_min && 'Table'[Ordered Date] <=_max) ) )

 

return

if(isblank(_cnt) , "No", "Yes")