Forum Discussion
Solved
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 ...
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
ppm1
Solution Sage
Solution SageI 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