Forum Discussion

LeahGJ's avatar
LeahGJ
Frequent Visitor
5 years ago
Solved

Creating a custom column based on a distinct count

Hi.     I have a hugggeee set of data with duplicated Purchase order transaction. I want to create a new column in the data set to count number of purchase order numbers.    Thanks 
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi LeahGJ ,

     

    You could use Dax formula:

     

    Column = DISTINCTCOUNT('Table'[Column1])

     

     

    Best Regards,

    Jay

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi LeahGJ ,

 

You could use Dax formula:

 

Column = DISTINCTCOUNT('Table'[Column1])

 

 

Best Regards,

Jay