Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Display filtered data simultaneously in the same column

Hello

I have the following tables and cutters:

DavidQues_0-1617025370016.png

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

DavidQues_1-1617025489331.png

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:
DavidQues_2-1617026561591.png

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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