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 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?
 

 

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.

2 Replies

  • 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!