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
  • mangaus1111's avatar
    mangaus1111
    3 years ago

    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.

mangaus1111's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
3 years ago

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.