Forum Discussion

arun90's avatar
arun90
Helper I
2 years ago
Solved

How to get opening date

my data has 3 dates(01-01-2023,02-01-2023,03-01-2023) in row but user select slicer in date between (02-01-2023 to 03-01-2023) then 01-01-2023 has to show 'opening' else 02-01-2023, 03-01-2023 in pow...
Need Help
Tips and Tricks
danextian's avatar
danextian
Super User
2 years ago

Hi arun90 ,

 

Can you please clarify? If the user selects dates between 02-01-2023 to 03-01-2023 what date do you expect as opening? And what do you mean by "else 02-01-2023, 03-01-2023"?

arun90's avatar
arun90
Helper I
2 years ago

Hi danextian ,

 My slicer have between dates,  i select some between dates my table docdate have to show less than of my date values show "opening" rest all have to show between dates,i attached screen shot for you reference.

Thanks.

 

 

 

  • danextian's avatar
    danextian
    Super User
    2 years ago

    Hi arun90 ,

     

    Going back to my question and basing on your screenshot, what date/dates are you expecting to appear in Opening Date column?

    • arun90's avatar
      arun90
      Helper I
      2 years ago

      Hi danextian 

      If the document date is prior to January 31, 2024, the opening date column should display "Opening"; otherwise, it should display the dates between January 31, 2024, and March 5, 2024, as per the selected slicer period.

       

      Thanks.

      • arun90's avatar
        arun90
        Helper I
        2 years ago

        Hi danextian

        you have any update on this concept ?

         

         

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    maybe try 

    if (max(document date )<min('date) ,"opening", max(doucment date))

    • arun90's avatar
      arun90
      Helper I
      2 years ago

      hi ryan_mayu 

      I need between dates for other than minimum date.

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        2 years ago

        could you pls provide some sample data(not screenshot)and the expected output