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.

    • 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.