Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
yyhk123
Frequent Visitor

distinct table with more than 1 fields

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!

1 ACCEPTED SOLUTION
mangaus1111
Solution Sage
Solution Sage

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.

View solution in original post

7 REPLIES 7
PaulDBrown
Community Champion
Community Champion

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

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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






mangaus1111
Solution Sage
Solution Sage

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
Continued Contributor
Continued Contributor

@yyhk123 ,

Hi

Do you want this in DAX or power query?

 

i want this to be in DAX
thank you!

@yyhk123 

Hi,

Remove Price and Program Name columns from visual table.

Thanks

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

@yyhk123 

Hi,

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

Thanks.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors