How to get opening date

[arun90]

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

[arun90]

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

[ryan_mayu]

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

[arun90]

Hi @ryan_mayu 

i attached the real time data sample and output 

[ryan_mayu]

@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]

Hi @ryan_mayu 

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

[ryan_mayu · Accepted solution]

pls see the attachment below

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

[arun90]

Hi @ryan_mayu 

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

[arun90]

@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]

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

[ryan_mayu]

you are welcome

[arun90]

@ryan_mayu 

[danextian]

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]

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]

Hi @danextian

you have any update on this concept ?