Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Showing Values Less than Date chosen

Hi , 

I have a table in this format  

I am trying to choose a date or range (for example when i choose 16-05-2019) the output should be 

but if I choose 19-05-19 I will want to see 

 

 

so the 15th line item is not included because it was canceled on the 18.

So Far I derived a column (showing the date it could show the line till),

  I created a date table to join on the derive date, but how can I show all the lines between the dates picked . I will explain further if needed. Thanks

Interesting Links

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous 

     

    You should be able to just create a date slicer visual, drag the date field onto it, and then change it to a date type of "before". This will allow the end user to choose the end date - all dates before it will be included.

     

    Hope this helps,

    Scott

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Attached screenshot.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Spowell, 

         

        In this example when I  use the before slicer for what happened befored the 19-01-19, it will include the 15-05-19 and  I want to exclude it because it was cancelled on the 18-01-19.