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]

Hi @ryan_mayu 

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

[ryan_mayu]

@arun90 

do the group by in the PQ

then each data will only have one row.

the rest steps are the same

[danextian]

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]

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.

[ryan_mayu]

maybe try 

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

[arun90]

hi @ryan_mayu 

I need between dates for other than minimum date.

[ryan_mayu]

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

[arun90]

Hi @ryan_mayu 

i have shared sample file link.

https://techsigaram-my.sharepoint.com/:x:/p/arunkumar_p/Ea76bTX1dcFNieBDPPbKW8MBqjV5-tgXCNDz5cD3SICZ... 

[ryan_mayu]

@arun90 

i can't open the link

[arun90]

@ryan_mayu Shall i share screen shot.

[ryan_mayu]

ok, pls also provide the expected output

[arun90]

@ryan_mayu SAMPLE

CONCEPT

[ryan_mayu]

so if we select 1/4, the opening will be 1/3? and the qty is 10040?

[arun90]

@ryan_mayu 

This concept the client use there ERP Software.

[arun90]

@ryan_mayu Yes .

[ryan_mayu]

pls see the attachment below

[arun90]

@ryan_mayu Thank you so much .it will work for only single date in slicer but its not working with between dates in slicer .

[ryan_mayu]

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

[arun90]

@ryan_mayu it will get the below data only

[ryan_mayu]

pls see the attachment below