add a column

[Anonymous]

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?

[Anonymous]

Could you try to explain whta you are looking for in a better way please?

[Anonymous]

@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]

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]

@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"