Forum Discussion
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...
NVM Amit, I manged to get the correct totals using sumx ! My bad. Pretty easy fix. I am just starting out but I have 1 issue I cannot wrap my head around shown below: My formula should retrieve just 1 last historic stage but in this instance it retrieves multiple? Why is that ? I am thinking it is due to my formula but could you help me fix this issue to only retrieve 1 historic stage with its correct amount ? It cannot have multiple stages as it will skew the measures