Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

add a column

Hello all, I am doing data profiling of multiple tables (around 45 tables) in one table(shown below). I also want to add an error count column to this.How can I do this?
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous I have created a query in which I have data profiling details about multiple tables columns like max, min value, null count standard deviation etc. I want an error count column too in it like null count.how can i achieve that?

dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi chahatkaur, 

I am not very clear about your requirement, did you mean when the null  count column is 0 or blank, you want to show it as other value? If so, you could  use condition in M code like : if [column] =0 or [blank]=null then condition A else condition B. If this is not what you want, please correct me and inform me more detailed information(sample data and expected output)? Then I will help you more correctly.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    dax hi, it has nothing to do with null count, it is just an example. i am using table.profile function for all my tables and appending them then. But by using table.profile function i dont get the error count column which i also want. I searched about it online and heard it can be done using custom table.profile function. I was able to get mode and median column like that, but still couldn't get the error count column.

    #"Profile" =
    Table.Profile(
    #"table1",
    {
    {"Median", each Type.Is(_, type number),List.Median} ,
    {"Mode", each Type.Is(_, type number), List.Mode}
    }
    )
    in
    #"Profile"