Min date for every client in a matrix live connect

[MC14]

Hello everyone,

I am new to PowerBI live connect. Below you can see a table, where I want to find out for each client the min date for category x.

Group	client	category1	date
1	a	x	01.01.2020
1	b	y	03.02.2020
1	c	x	02.01.2020
1	a	z	...
2	d	x
2	e	t

When I visualize this in a matrix, where I have the group and client on the rows and the columns show the date, it takes the date 01.01.2020 for every client. 

group 1	min date
a	01.01.2020
c	01.01.2020

However, what I want is to get the min date of each client separately, i.e.

group 1	min date
a	01.01.2020
c	02.01.2020

 I tried to solve this by using Keepfilters, but it did not work.

Thank you in advance.

[onurbmiguel_ · Accepted solution]

Hello MC14

can you try this measure: 

Client Date min = 
var _client = SELECTEDVALUE('Table'[client])
var _value = 
    CALCULATE(
        MIN('Table'[date]),
        filter(all('Table'),'Table'[client]=_client)
    )
return 
_value

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC

[MC14]

Thank you for your response! It worked !

Best Regards MC