Latest value from date field

[jalaomar]

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 latest value from the latest month (July 2023)

but using below measure, it return the 2023-12-01 value, how can I modify so that it excludes the buget and forecast value?

Last FI Value = CALCULATE( SUM(RPM[Orders received]); FILTER(RPM;RPM[Date]=MAX(RPM[Date])))

in the table there are the following column, So would like to extract value for July month (1000) only.

anyone who can support?

[Anonymous · Accepted solution]

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]

@Anonymous Awsome this is exactly what I was looking for 

Thanks!