Forum Discussion

nicholas058's avatar
nicholas058
Frequent Visitor
2 years ago

Creating a Measure/Column Which Shows the Most Recent Value and one which shows the Oldest

Good Morning,    My first post on this forum, so I apologize if I'm not wording the question appropriately. However, I'm struggling to figure this out based on the existing articles I've looked at,...
nicholas058's avatar
nicholas058
Frequent Visitor
2 years ago

Hi Anonymous 

 

This is close, but not exactly what I'm trying to accomplish. 

 

I would like to create a measure that shows the most recent value, and another that shows the oldest value, which will allow me to have only one instance of the quote in the row. 

 

Here is a pictured version. I've also attached this much abbreviated datasheet, as well as a dummy project file to play with. 

 

Abbreviated Data Excel 

Sample PBI 

  • nicholas058's avatar
    nicholas058
    Frequent Visitor
    2 years ago

    Hey there, this was super helpful, however I'm running into another issue! It refuses to aggregate these totals. As you see in the example above, the totals are just the last line. I need to know the total sum of these changes. 

     

    In my report....

     

    For sample data, you can still use the PBIX you provided above

     

     



    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      you did not specify that requirement before.  You will need to summarize by Line Name to get the totals.

       

      Most Recent New Value = 
var a = SUMMARIZE('Table','Table'[Line Name],"md",max('Table'[CreatedDate]))
var b = ADDCOLUMNS(a,"sm",var md = [md] return CALCULATE(max('Table'[NewValue]),'Table'[CreatedDate]=md))
return sumx(b,[sm])