Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need to fix the dax query!

Dear Expert, i need to fix my dax. its not working or getting the right value...   Requirements: Period must be possible to change in the Report (Start and End date) Average stock value: - Stock...
Need Help
Tutorial Requests
Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

Anonymous i Hope this helps you!THANK YOU!!
Begining Stock Value = CALCULATE([totalcost],filter(ALLSELECTED('ValueDate[Date]),'ValueDate[Date]<Period Start)))
Ending Stock Value = CALCULATE([totalcost],filter(ALLSELECTED('ValueDate[Date]),'ValueDate[Date]<Period Start)))

ELSE USE THIS


Begining Stock Value = CALCULATE([totalcost],filter('ValueDate'[Date],'ValueDate'[Date]<Period Start)))
Ending Stock Value = CALCULATE([totalcost],filter('ValueDate'[Date],'ValueDate'[Date]<Period Start)))