Forum Discussion

jalaomar's avatar
jalaomar
Helper IV
3 years ago
Solved

Latest value from date field

Hello,   I have a dataset where I get the cumulative value each month and within that same column there is full year Budget and Forecast value 2023-12-01   What I want to do it to capture the lat...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi, jalaomar 

     

    You can try the following methods.

    Last FI Value =
CALCULATE (
    SUM ( RPM[Orders received] ),
    FILTER (
        RPM,
        RPM[Date]
            = CALCULATE ( MAX ( RPM[Date] ), FILTER ( ALL ( RPM ), [Date] <= TODAY () ) )
    )
)

    Is this the result you expected?

     

    Best Regards,

    Community Support Team _Charlotte

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi, jalaomar 

 

You can try the following methods.

Last FI Value =
CALCULATE (
    SUM ( RPM[Orders received] ),
    FILTER (
        RPM,
        RPM[Date]
            = CALCULATE ( MAX ( RPM[Date] ), FILTER ( ALL ( RPM ), [Date] <= TODAY () ) )
    )
)

Is this the result you expected?

 

Best Regards,

Community Support Team _Charlotte

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

  • jalaomar's avatar
    jalaomar
    Helper IV
    3 years ago

    Anonymous Awsome this is exactly what I was looking for 

    Thanks!