Forum Discussion

legendsfan's avatar
legendsfan
Frequent Visitor
9 years ago
Solved

Finding the most recent value change

Requirement:  Create a custom column that lists the most recent updated start date.   Background: PSOW # is always required. PCR # is only used if there are ammendments to orginal PSOW #.  PCR # alw...
Need Help
  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    9 years ago

    I wasn't following your description, but purely by looking at your expected result I suspect you can acheive this easily in the query editor.

     

    You can "Group By" PSOW# and add two aggregations: SUM of Cost and MAX of Start Date.  See if that works.  I'm not 100% sure about the MAX of Start Date but try it and let us know

dkay84_PowerBI's avatar
dkay84_PowerBI
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
Not sure I follow you. Did you follow my steps? That will produce the result you showed
legendsfan's avatar
legendsfan
Frequent Visitor
9 years ago

I edited my previous post as it looks like I left out a couple words :)  I chose to use a Measure using LastNonBlank instead of Max but assume both will work.  What I'd like to do within the code of the measure is ensure the data is sorted correctly so it always evaluates this highest PCR # first.