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
ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

if we select 1/3 - 1/6 ,what the expected output. pls also provide it

arun90's avatar
arun90
Helper I
2 years ago

ryan_mayu it will get the below data only

 

  • arun90's avatar
    arun90
    Helper I
    2 years ago

    ryan_mayu Thank you so much ,i done a great job for me.i will work with my real data and get back to you.once again thank you.

  • arun90's avatar
    arun90
    Helper I
    2 years ago

    ryan_mayu my real data exp for opening=(

    Opening1 = if('STOCKVALUE'[DOCDATE]=min('STOCKVALUE'[DOCDATE]),STOCKVALUE[recqty]-STOCKVALUE[issqty],sumx(FILTER('STOCKVALUE','STOCKVALUE'[DOCDATE]<EARLIER('STOCKVALUE'[DOCDATE])),STOCKVALUE[recqty])-sumx(FILTER('STOCKVALUE','STOCKVALUE'[DOCDATE]<EARLIER('STOCKVALUE'[DOCDATE])),STOCKVALUE[issqty])) 

    )

     

    open=

     if(MIN('STOCKVALUE'[DOCDATE])=MIN('Calander1'[Date])-1,sum(STOCKVALUE[Opening1]),0)  but not working this exp
     

     

  • arun90's avatar
    arun90
    Helper I
    2 years ago

    ryan_mayuand one thing, my actual data doesn't have continuous dates.

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    you are welcome

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    pls update the sample data and expected output. you can directly paste the sample data in the reply

  • arun90's avatar
    arun90
    Helper I
    2 years ago

    Hi ryan_mayu 

     

    i attached the real time data sample and output 

     

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    arun90 

    create a table which contains continous days.

    Table 3 = CALENDAR(min('Table'[Opening date]),max('Table'[Opening date]))
     
    then get the recqty and issueqty data from orignial table
    issueqty = RELATED('Table'[issueqty])
    Recqty = RELATED('Table'[Recqty])
     
    then do the similar work on the new table to get the expected output
     
    pls see the attachment below
  • arun90's avatar
    arun90
    Helper I
    2 years ago

    Hi ryan_mayu 

     

    Some dates are showing null recodes but that date no need to show for this filter

     

     

     

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    pls see the attachment below

     

    Appreciate your kudos. if my solution is helpful, pls mark it as an accepted solution. Thanks

  • arun90's avatar
    arun90
    Helper I
    2 years ago

    Hi ryan_mayu 

    Thanks for your support i will check and confirm with you.