Dax list account from start year to selected date

[majid_75]

Hello,

I have un problem, pls help me

i have a table and 2 selecters (Year and Month).

I want to have the list of clients filtered on the date from the beginning of the year to the selected month end date

Year	2020
Month	8
Account	Date
AA	01/02/2020
A	01/02/2020
B	05/03/2020
C	07/04/2020
D	10/05/2020
E	12/06/2020
F	15/07/2020
G	17/08/2020
H	19/09/2020
I	22/10/2020
J	24/11/2020
K	27/12/2020

Here is my measurement but I can’t display the customer name, only the count.

CALCULATE(

DISTINCTCOUNT(ta_fact_sales[Name]),

FILTER(

ALL('Date'),

'Date'[Year]=YEAR(DATE(LEFT( SELECTEDVALUE('Date'[Yearmonth]),4),RIGHT( SELECTEDVALUE('Date'[Yearmonth]),2),1 ))

&& 'Date'[Yearmonth] <= SELECTEDVALUE('Date'[Yearmonth])

&& 'Date'[Date] >= STARTOFYEAR('Date'[Date])

))

Thanks

[lbendlin]

You can use an iterator function like CONCATENATEX() to get the list of accounts that satisfy your filter criteria.