cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
makhdoomliaqat
Frequent Visitor

Value According to date

Hello,

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

makhdoomliaqat_0-1633780472032.png

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

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@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]))

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

3 REPLIES 3
Fowmy
Super User
Super User

@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]))

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


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

makhdoomliaqat_0-1633784811792.png

 

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 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.