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 power bi

Need Help
Tips and Tricks

34 Replies

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

     

    i have faced some issue from your solution ,i attached the original data set for your reference.

     

     

     

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      2 years ago

      arun90 

      do the group by in the PQ

       

      then each data will only have one row.

       

      the rest steps are the same