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!

[PaulDBrown]

If you need to create a new table (not a visual), use:

Summarized Table = SUMMARIZE(Table, Table[Customer ID], Table[Date])

[mangaus1111 · Accepted solution]

Hi @yyhk123 ,

if you ant to create another table you can use this

Table = 
SUMMARIZE('Facts17',
    'Facts17'[Customer ID],
    'Facts17'[Date]
    )

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Dinesh_Suranga]

@yyhk123 ,

Hi

Do you want this in DAX or power query?

[yyhk123]

i want this to be in DAX
thank you!

[Dinesh_Suranga]

@yyhk123 

Hi,

Remove Price and Program Name columns from visual table.

Thanks

[yyhk123]

I am using that field to create another table
is there a way without removing the columns?

[Dinesh_Suranga]

@yyhk123 

Hi,

You don't need to remove fields from data table. Don't use it to table visual.

Thanks.