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