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!
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
2 Replies
ppm1Solution Sage
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
- Ashish_Mathur
Super User
Hi,
To your Table visual, drag Customer ID and write this measure
Min date = min(Data[Date])
Hope this helps.
