Forum Discussion
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!
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.
7 Replies
- mangaus1111
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
i want this to be in DAX
thank you!- Dinesh_Suranga
PaulDBrownCommunity Champion
If you need to create a new table (not a visual), use:
Summarized Table = SUMMARIZE(Table, Table[Customer ID], Table[Date])
