Value According to date

[makhdoomliaqat]

Hello,

i have grid like below. I need simply values of items and POS wise according to date creteria.

i am using date creteria. and find out the according to date if i add card it should show on first value = 312,000 and end value = 0

Please help

[Fowmy · Accepted solution]

@makhdoomliaqat 
Not entirely clear about the requirement, but you can add the following two measures to show the 1st and last values on card visuals based on the dates.

First Value = FIRSTNONBLANKVALUE( TableName[Date] , sum(TableName[ Fifoclosinginhand]))

Last Value = LASTNONBLANKVALUE( TableName[Date] , sum(TableName[ Fifoclosinginhand]))

[makhdoomliaqat]

i Used it when i am working on same item it is showing correct result but when i change item its showing wrong.

See this

the result of first value should be 0 and last value is also zero because i am taking the creteria from 

01-01-2019 to 31-12-2019 

in this i have no record on 01-01-2019.

[Fowmy]

@makhdoomliaqat 

Sorry, I am not able to follow what you trying to achieve, please share a file with sample or dummy data to show the expected output.

Thanks