Forum Discussion

misc981's avatar
misc981
Frequent Visitor
1 year ago
Solved

Filter table based on selection in another table

I have a SP datasource describing user leave requests with columns 'Leave Type, 'To' and 'From' columns. The exact dates for each and every day is not available, only the 'To' and 'From' columns. Our...
Need Help
  • Shahid12523's avatar
    Shahid12523
    1 year ago

    Don’t make 7 tables → create one Next7Days table with dates TODAY() → TODAY()+6.

     

    Use a measure like:

     

    IsOnLeave =
    VAR d = SELECTEDVALUE(Next7Days[Date])
    RETURN IF( MAX(Leaves[From]) <= d && MAX(Leaves[To]) >= d, 1, 0 )


    Filter the leave detail table with IsOnLeave = 1.

    Add slicer for Leave Type → both date + type filter will apply.

     

    Much cleaner than 7 visuals.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi misc981  ,

I would also take a moment to thank Shahid12523 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi misc981 ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi misc981 ,
    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions