Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |