Forum Discussion
cdawidow2
4 years agoFrequent Visitor
Last Value from a table?
Hi guys, I want to build a dax measure that essentially allows me to calculuate the Stage Name & Amount of a sales opportunity in my pipeline historically. I have both CreatedDate and systemmodstam...
amitchandak
Super User
4 years agocdawidow2 , the expected output is not clear
Try
lastnonblankvalue(CreatedDate , Sum(Table[Amount]) // Or use Amount Measure
lastnonblankvalue(systemmodstamp , Sum(Table[Amount]) // Or use Amount Measure
or
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.