Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Data Density in Table

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.


Need Help
Tutorial Requests

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    9 years ago

    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

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    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