topic Re: New customers names in DAX Commands and Tips

New customers names

Girish-Patil — Fri, 08 Sep 2023 08:17:19 GMT

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

Re: New customers names

eliasayyy — Fri, 08 Sep 2023 09:28:08 GMT

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?

Re: New customers names

technolog — Fri, 08 Sep 2023 09:54:04 GMT

eliasayyy please paste it in text mode, not like screenshots

Re: New customers names

eliasayyy — Fri, 08 Sep 2023 09:57:10 GMT

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

Re: New customers names

eliasayyy — Fri, 08 Sep 2023 09:57:44 GMT

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

Re: New customers names

technolog — Fri, 08 Sep 2023 09:59:39 GMT

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

Re: New customers names

eliasayyy — Fri, 08 Sep 2023 10:00:13 GMT

haha technolog its ok understandable

Re: New customers names

Girish-Patil — Fri, 08 Sep 2023 10:26:01 GMT

Thank you annonymous1999, It worked...!😃