Forum Discussion
Descriptive statistics table
Would it be possible to generate something like this in Power BI? Currently, I can calculate the values individually for the variables, but I would like to have one single table if possible. ...
Maybe, would need to understand underlying source data.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Source data:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcszLS1XSUXJLzU3MATGMTJVidaKV3IoS84A8X6igOVjQKxFNrSFEOD8VSakxVCwDWb8JWNA7sQRVvyVY2DexKD2xKLUERcoCJlWJImwGFg7Jz0UyHOiKWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Name = _t, Gender = _t, Age = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Gender", type text}, {"Age", Int64.Type}}) in #"Changed Type"Expected result:
Categorical variables
Continuous variables
Sample Size (N)
% (n/N)
Mean
Median
SD
IQR
Age
8
25.4
25.5
2.7
3.5
Gender
7
Male
42.9% (3/7)
Female
57.1% (4/7)
