A CALCULATE SUM DAX question based on latest value

[rileybloke]

Hi All, banging my head against the desk now, so have to ask the pro's... I have a set of data like this...

Doc No		Doc Date	Item	Qty
1		01/02/2014	111	10
1		01/02/2014	112	15
2		01/02/2014	113	20
2		01/02/2014	111	10
4		03/02/2014	111	10
5		05/02/2014	113	10
6		06/02/2014	111	10
7		07/02/2014	112	10
8		08/02/2014	111	10

<tbody>
</tbody>

I need to sum the qty for each Doc No, by date but only the DocNo with the highest number, ignoring any previous docs.
Thanks

 

[greg kramer]

Apologize if this is a stupid question but can you say what exactly the 30 is comprised of on 01/02/14. Suspect there is some simple misunderstanding.

Thanks.

 

[mozartiano]

Then you can change the MAX syntax to include that column, something like LatestDocNo=calculate(max(Table1[Doc No]),filter(Table1,Table1[MSGDATE]=earlier(Table1[MSGDATE])))

?

 

[greg kramer]

Nicely done Tianbas!I was able to get the desired results with the example data with your approach. Seems Mozartiano addressed the latest twist with a slight tweak.

 

[rileybloke]

Sorted! thanks guys!