Forum Discussion

pucities's avatar
pucities
Frequent Visitor
6 years ago
Solved

Data Profiling in M: Count of Numeric Values (Table.Profile)

Hello,   I created a data profiling table in Power Query from a table(T_File)   let Source = Table.Profile(T_File) in Source     How do I add another aggregate column to the data profile ta...
Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    Hi pucities 

    Please try this:

    List.Count(List.Select( Source[Column1], each try Value.Is(Number.From(_), type number) otherwise null))

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi pucities 

Before Profile, please change type of your column from varchar to number format.

Please pay attention to the notes below:

The second part: A function to call to determine where the aggregate column will be applied to a given column in the source table. In this case I’m checking to see if a column is type number and only returning a median or mode if it is.

 

Reference:

https://ssbi-blog.de/blog/technical-topics-english/pitfalls-with-table-columnsoftype/

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.