distinct table with more than 1 fields

[yyhk123]

Hi,
How can i recreate a table from step 1 to step 2 below? (in DAX)

1.
Customer ID | Price | Program Name | Date

ABC                 $100    Show                 10/1/2022

ABC                 $50      Movie                10/1/2022

EFG                 $100    Show                  10/5/2022

EFG                 $100    Show                  10/5/2022

XXX                 $100    Show                 10/9/2022

XXX                 $50      Movie                10/9/2022

YYY                 $100    Show                  10/15/2022

YYY                 $100    Show                  10/15/2022

from above to somthing like this:
Customer ID |  Date

ABC                10/1/2022

EFG                 10/5/2022

XXX                 10/9/2022

YYY                 10/15/2022

think i need to use DISTINT but not sure how i can add additional fields like date

thank you!

[Ashish_Mathur]

Hi,

To your Table visual, drag Customer ID and write this measure

Min date = min(Data[Date])

Hope this helps.

[ppm1 · Accepted solution]

I would do this in the query editor, but you can do it in DAX too with this table expression

NewTable = SUMMARIZE(Table, Table[CustomerID], Table[Date])

Replace Table with your actual table name.

Pat