Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@Anonymous i just found this which might help
https://blog.crossjoin.co.uk/2016/01/19/the-table-schema-function-in-power-bim/
Proud to be a Super User!
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêsthnxx, 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 .
@Anonymous i just found this which might help
https://blog.crossjoin.co.uk/2016/01/19/the-table-schema-function-in-power-bim/
Proud to be a Super User!
@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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |