Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @LeahGJ ,
You could use Dax formula:
Column = DISTINCTCOUNT('Table'[Column1])
Best Regards,
Jay
Hi @LeahGJ ,
You could use Dax formula:
Column = DISTINCTCOUNT('Table'[Column1])
Best Regards,
Jay
Hey @LeahGJ ,
please take the time to create a pbix file that contains sample data but still reflects your data model, upload the pbix file to onedrive or dropbox and share the link. If you are using Excel to create the sample data share the xlsx as well.
Describe the expected result based on the sample you created.
Regards,
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |