Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Text Distinct Count

Hi All,   I have a dataset similar to the below.   Date ID Fail Reason 01/01/2021 1 Too big 01/02/2021 1 Too small 02/01/2021 2 Incorrect  03/02/2021 3 Too big   Col...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Refer Arul  solution. Also, check do you have some space around the other 1. Use trim and lean in power query to clean ID column

    Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4

Arul's avatar
Arul
Super User
4 years ago

Hi Anonymous ,

 

I am getting the correct value while using the sample dataset with which you were provided. I have used Count (Distinct) option.

 

Thanks,

Arul