Data Density in Table

[Anonymous]

Hello,

I have the following question related to data quality and data density. Is there anyway to build an Overview for data?
For example, I have a huge table with many columns, and I want to another table or even a graphic that showes me, like what is my datatype in the columns ,what is my max and min value in certain culomns that i choose from an exisiting table. any idea how to do such a thing, or even Power bi support such views and staticistics.

[MFelix]

Hi @Anonymous,

Check this post and use the Table.Schema(YourTable) formula to make a summary of you table, you can the also add the max and minimuns value os calculate the statistc you need to have the data for a summary, even a 

Any question please tell me

Regards,

MFelix

[Anonymous]

thnxx, with my low expreiance in Power Query Formula Language, i am not sure how to do it, but any guidlines might help me to do it .

[vanessafvg · Accepted solution]

@Anonymous i just found this which might help

https://blog.crossjoin.co.uk/2016/01/19/the-table-schema-function-in-power-bim/

[vanessafvg]

@Anonymous i think that is something you woudl have to prebuild

you can get data profiler tools to do this but i dont think power bi does this automatically, is something you would have to profile yourself and write the code for