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.

Dinesh_Suranga's avatar
Dinesh_Suranga
Icon for Continued Contributor rankContinued Contributor
3 years ago

yyhk123 ,

Hi

Do you want this in DAX or power query?

 

yyhk123's avatar
yyhk123
Frequent Visitor
3 years ago

i want this to be in DAX
thank you!

  • Dinesh_Suranga's avatar
    Dinesh_Suranga
    Icon for Continued Contributor rankContinued Contributor
    3 years ago

    yyhk123 

    Hi,

    Remove Price and Program Name columns from visual table.

    Thanks

    • yyhk123's avatar
      yyhk123
      Frequent Visitor
      3 years ago

      I am using that field to create another table
      is there a way without removing the columns?

      • Dinesh_Suranga's avatar
        Dinesh_Suranga
        Icon for Continued Contributor rankContinued Contributor
        3 years ago

        yyhk123 

        Hi,

        You don't need to remove fields from data table. Don't use it to table visual.

        Thanks.