DAX Filtering between dates with KEEPFILTER

Since originally posting I have also crosspostd at MR Excel ;

Please Login or Register  to view this content.

Hi,

I've attached workbook with a p pivot which I'm trying to to in PBi,

The formula I've used is

Please Login or Register  to view this content.

In Pbi I thought I would be able to use just KF even thought I'd not got it to work in power pivot;

Please Login or Register  to view this content.

the problem seems to be with the MAX(Pdate[Sdate]) part as if I use

Please Login or Register  to view this content.

This works, so I want to get it with the daets from Pdate?

Finally is it possible to do this with DATESBETWEEN? again I just get the grand total .

Richard.