Forum Discussion
How do I create a table of descriptive stats from numerous data sources?
Hi... to get this stats for each table, you can use this function in Power Query:
let
Source = Table.Profile(#"YourTableName")
in
SourceThis will create a table, where each column of your table will be represented by single row and information about Min, Max, StandardDeviation, Average, Count, NullCount and DistinctCount will be provided. On top of it, you can create some or your own measures, e.g. completness, etc.... but is missing Mean, Mode and Median
You can do it for all tables, add new column with table name and then append them to a final single table 😉
I hope this helps 🙂
Community SupportHi MeggieD00dles ,
Thanks for reaching out to the Microsoft fabric community forum.
lbendlin , ivana_tomekova Thanks for the prompt response
I wanted to follow up and confirm whether you’ve had the opportunity to review the information provided by lbendlin , ivana_tomekova If you have any questions or need further clarification, please don’t hesitate to reach out.
We appreciate your collaboration and support!
Best regards,
Lakshmi.
Community SupportHi MeggieD00dles ,
We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.
We appreciate your engagement and thank you for being an active part of the community.
Best Regards,
Lakshmi.