Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Latest customer names

This seems like something simple and I'm struggling. I feel like no matter how many books I'm reading (I have 4 PQ/PBI/DAX books in front of me), this is just not working.    I'm looking to list t...
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Here is one way to do it

 

ListOfCustomers =
VAR mindate =
    MIN ( 'Date'[Date] )
VAR currentcustomers =
    VALUES ( Table[Customer] )
VAR previouscustomers =
    CALCULATETABLE (
        VALUES ( Table[Customer] ),
        ALL ( 'Date' ),
        'Date'[Date] <= mindate
    )
VAR newcustomers =
    EXCEPT ( currentcustomers, previouscustomers )
RETURN
    CONCATENATEX ( newcustomers, Table[Customer], "; " )

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat