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

     

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.