Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Identify 2 different rows under the same table

Hi All,   I have the below table and use the slicer select report date. When the user selected 14-Feb to 28-Feb in the slicer. I want to compare all records from 14-Feb and 28-Feb. Identify which o...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks all,

     

    Let me take some time to apply the above solution and let you know the outcome. 


    Many thanks

    Clement

     

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 

the slicer is based on which column? Or do you have a date table? If so to which column it connects?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi 

 

The slicer column is based on the report date column. I did not create another date table.

 

Thanks

Clement 

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Anonymous 
    You can start with creating a slicer table from the report date column

     

    Date Selection =
VALUES ( Table[Report Date] )

     

    Then create the slicer from the new table.
    Now use thrf oloowing code to create a filter measure

    Filter Measure =
VAR FirstDateInSlicer =
    MIN ( 'Date Selection'[Report Date] )
VAR LastDateInSlicer =
    MAX ( 'Date Selection'[Report Date] )
VAR CurrentDateInVisual =
    MAX ( Table[Report Date] )
RETURN
    OR (
        CurrentDateInVisual = FirstDateInSlicer,
        CurrentDateInVisual = LastDateInSlicer
    )

    Place the filter measure in the filter pane and select "is" and insert value "1" then apply.