New customers names

[Girish-Patil]

I want to get the new added customers name this week i tried with many ways im not getting the requierd output can anyone help with this issue??

Dataset

Customer_name	State	date	Start of week
A1	Regular	01-01-2022	01-01-2022
A2	Prime	02-01-2022	01-01-2022
A3	Elite	03-01-2022	01-01-2022
A4	Regular	0 4-01-2022	01-01-2022
A1	Prime	08-01-2022	08-01-2022
A2	Prime	09-01-2022	08-01-2022
A3	Elite	10-01-2022	08-01-2022
A4	Elite	11-01-2022	08-01-2022
A5	Regular	12-01-2022	08-01-2022
A6	Regular	13-01-2022	08-01-2022
A7	Prime	14-01-2022	08-01-2022

Required Output 1

Start of Week	New Customers
08-01-2022	A5, A6, A7

O/P 2

	08-01-2022
Regular
Prime	A1
Elite	A4

[eliasayyy · Accepted solution]

hello @Girish-Patil  
here is data

here is first measure for first output 

New Customers = 
VAR CurrentWeek = MAX('Table'[Week])
RETURN
    CONCATENATEX(
        FILTER(
            SUMMARIZE('Table', 'Table'[Customer]),
            CALCULATE(
                MIN('Table'[Week]),
                ALLEXCEPT('Table', 'Table'[Customer])
            ) = CurrentWeek
        ),
        'Table'[Customer],
        ", "
    )

output 1 

now for output 2 i didnt know hwo t oacheive it honestly 

@tamerj1 @some_bih  @ERD @technolog any ideas how he can get his second output?

[Girish-Patil]

Thank you annonymous1999, It worked...!😃

[technolog]

@eliasayyy please paste it in text mode, not like screenshots

[eliasayyy]

@technolog i helped out for the first ouput however not sure about the second output

[eliasayyy]

@technolog look at the first qiestion i am helping out the person he already has text data not image

[technolog]

@eliasayyy Oh, sorry! I guess I'm not awake yet!😅

[eliasayyy]

haha @technolog its ok understandable