Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! 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
@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
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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |