Return Date if ISINSCOPE of Customer

[piotr_gor]

Hi, 

I want to create measure that returns Date of Document if in matrix I'm in scope of Customer. 

That's my sample data:

Customer Name	Document	Date	Sales Amount
Customer1	FV1	01.01.2023	€            100,00
Customer1	FV2	01.02.2023	€            150,00
Customer1	FV3	05.01.2023	€            150,00
Customer1	FV4	21.01.2023	€              25,00
Customer1	FV5	23.01.2023	€            200,00
Customer2	FV1	01.01.2023	€        1 000,00
Customer2	FV2	13.01.2023	€            500,00

And what I want to achieve is something like that:

How do I achieve that? 

Tried to use code like below but it didn't work:

Measure = 
IF( 
  ISINSCOPE(  'Table'[Customer] ),
  MAXX ( 'Table', 'Table'[Data] ) 
)

[Padycosmos]

Hope this helps