Forum Discussion

SammyNed's avatar
SammyNed
Icon for Helper I rankHelper I
2 years ago

Create a Filter based on a Slicer date

Hi everyone

 

Could i please get some assistance?

 

I have some dummy data below, in essence we have a users table, a user login table and a date table (relationships shown in the second snapshot). The users highlighted in yellow below are the users registered in the selected date range

 

 

The date table is used in the report as below. I want to add a filter/slicer to say if the user was registered during the selected filtered date or not. So a simple checkbox stating Yes or No (if the user was registered during the sliced date range)

 

Is this possible?

 

Thanking you in advance

Sammy

 

1 Reply

  • Rupak_bi's avatar
    Rupak_bi
    Icon for Super User rankSuper User
    2 years ago

    Hi,

     

    Try to create a measure : if(max(User,registration date)=selectedvalue(date table, date),"Yes","No"). Plot this measure in a Marix.