Forum Discussion

Frequent Visitor

4 years ago

Solved

Value According to date

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
4 years ago
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]))

3 Replies

Fowmy
Super User
4 years ago
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
  Frequent Visitor
  4 years ago
  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
    Super User
    4 years ago
    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

Related content