- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Latest Date Value Measure
Hi,
Number - Lots = CALCULATE( MAX('Data'[Number - Lots (Original)]), FILTER( ALL('Data'), 'Data'[Date - Trade] = MAX('Data'[Date - Trade]) ) )
I have the measure above thats aim to take the last number in a period of time. For Example from below I would only want to see 12 as the result.
01 Jan 21 - 10
02 Jan 21 - 11
03 Jan 21 – 12
This is working when there is only 1 number per date. If there is more than 1 number it is not summing them together. In the example below I would want it to return 15 but it’s returning either 3 or 12.
01 Jan 21 – 10
01 Jan 21 – 15
02 Jan 21 - 5
02 Jan 21 - 11
03 Jan 21 – 12
03 Jan 21 - 3
Can you please assist me in fixing this?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @CM_Mills,
Can you try the following measure?
Measure =
VAR _maxDate = MAX( 'Table'[Date] )
RETURN
CALCULATE(
SUM( 'Table'[Value] ),
'Table'[Date] = _maxDate
)
Here is what I get on my side:
If I answered your question, please mark my post as a solution.
Best,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @CM_Mills,
Can you try the following measure?
Measure =
VAR _maxDate = MAX( 'Table'[Date] )
RETURN
CALCULATE(
SUM( 'Table'[Value] ),
'Table'[Date] = _maxDate
)
Here is what I get on my side:
If I answered your question, please mark my post as a solution.
Best,

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
08-16-2024 12:23 AM | |||
06-05-2024 10:40 AM | |||
05-20-2020 11:37 AM | |||
01-03-2023 10:28 PM | |||
12-01-2023 04:58 AM |
User | Count |
---|---|
24 | |
13 | |
11 | |
10 | |
9 |
User | Count |
---|---|
18 | |
14 | |
14 | |
13 | |
12 |