Forum Discussion

yyhk123's avatar
yyhk123
Frequent Visitor
3 years ago
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     ...
Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    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's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

To your Table visual, drag Customer ID and write this measure

Min date = min(Data[Date])

Hope this helps.