Forum Discussion

PaulPalkowski's avatar
PaulPalkowski
Icon for Helper II rankHelper II
6 years ago

Looking for Last Value for each

I have this near complete... What would I use to get the "last value", or the value with the most recent date/time  Each site has about 60,000 records   Do you need more info to help me on this? ...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi PaulPalkowski ,

 

Try to create a measure or column:

mostRecentDate = CALCULATE(MAX(table[LastDate]),ALLEXCEPT(table,table[Site]))

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • PaulPalkowski's avatar
    PaulPalkowski
    Icon for Helper II rankHelper II
    5 years ago

    I have the last date... I need the VALUE from that last date..

    I have Min Value, Max Value, Avg Value for each, just need a new column for the LAST value 

     

    • PaulPalkowski's avatar
      PaulPalkowski
      Icon for Helper II rankHelper II
      5 years ago

      here is what my data looks like

      Looking for value of last date for each SITE and AREA

      • V-lianl-msft's avatar
        V-lianl-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi PaulPalkowski ,

         

        Try:

        Measure = CALCULATE(LASTNONBLANK('Table'[VALUE],0),ALLEXCEPT('Table','Table'[SITE],'Table'[AREA]))

Column = CALCULATE(LASTNONBLANK('Table'[VALUE],0),ALLEXCEPT('Table','Table'[SITE],'Table'[AREA]))

         

         

        Best Regards,
        Liang
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.