Display filtered data simultaneously in the same column

[DavidQues]

Hi,

I have the following tables and slicers:

But I would like the Commitments to displayed as follows. But then Actuals and a bunch of other stuff are incorrect. 

How can I do this dynamically where for Commitments it selctes the lastest report run date per posting period key and displayes it togeather in the same column?

I have a working latest date per period measure: 

          Max Date =

          VAR PeriodRef = SELECTEDVALUE('Table'[Period Ref])

         RETURN

         MAXX(FILTER(ALL('Table'), 'Table'[Period Ref] = PeriodRef),

         'Table'[Report Run Date])

Thanks.

Here was my attempt to solve it:

       All Commitments2 =

             CALCULATE(SUM('Table'[Commitments]),

             FILTER('Table','Table'[Report Run Date] IN {[Max Date]}))

It some what works, because it only shows Commitments for the the lastest run dates by period. But I couldn't figure out how to correctly add to this measure to also select all the run dates. Here are the correct Commitments if I manually select all the report run date on the slicer:

[amitchandak]

@DavidQues , if you want to filter a date twice, You need atleast one independent table to do that

refer: https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[DavidQues]

Hi amitchandak,

Thanks! 

So I treated actuals as current year and commitments as prior years and applied your solution, here are the resutls:

How can I edit your Dax for New Commitments, so instead of a min and max range, it selects the lastest report run date per period.

For example, right now when I manually select the lastest report run dates from Commitment.reprot run date, it treats it like the min and max and also incldues March 9th, which I don't want.