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 = 0Please help
Go to 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]))
⭕ Subscribe and learn Power BI from these videos ⚪ Website ⚪ LinkedIn ⚪ PBI User Group
View solution in original post
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.
@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
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.