Forum Discussion

MeggieD00dles's avatar
MeggieD00dles
Frequent Visitor
11 months ago
Solved

How do I create a table of descriptive stats from numerous data sources?

I can't seem to find an answer that works for me, so looking to you all for help.   In my PBI report I have numerous data sources (in the example file, each "example table" is a separate data sourc...
Need Help
  • ivana_tomekova's avatar
    ivana_tomekova
    11 months ago

    Hi... to get this stats for each table, you can use this function in Power Query: 

    let
    Source = Table.Profile(#"YourTableName")
    in
    Source

     

    This 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 🙂

     

ivana_tomekova's avatar
ivana_tomekova
Icon for Advocate II rankAdvocate II
11 months ago

Hi... to get this stats for each table, you can use this function in Power Query: 

let
Source = Table.Profile(#"YourTableName")
in
Source

 

This 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 🙂

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    11 months ago

    Or the DAX equivalent COLUMNSTATISTICS()