Display filtered data simultaneously in the same column

[Syndicate_Admin]

Hello

I have the following tables and cutters:

But I would like the commitments to be shown as follows. But then the real ones and a lot of other things are wrong.

How can I do this dynamically where for Commitments the report execution date is seeded plus lastest by posting period key and displays it in the same column?

I have one last working date per period measure:

Maximum Date ?

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

Return

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

'Table'[Report Execution Date])

Thank you.

Here was my attempt to solve it:

All commitments2

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

FILTER('Table','Table'[Report Execution Date] EN ?[Maximum Date]))

It's something that works, because it only shows commitments for the last execution dates per period. But I couldn't figure out how to correctly add to this measure to also select all execution dates. Here are the correct commitments if I manually select the entire report execution date in the slicer:

[Anonymous]

Hi @Syndicate_Admin ,

Based on your description,  do you want to find the latest date among the selected dates and display in the matrix the value pair in the "commitment" column where the date matches the latest date? If my understanding is wrong, please feel free to let me know. 

Could you please share some sample data( raw table) and the expected result to have a clear understanding of your question? I can do some tests for you.😊

You can save your sample files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.

Best Regards,

Yuna

[amitchandak]

@Syndicate_Admin ,

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