Forum Discussion

smann's avatar
smann
Helper I
8 years ago

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.    ...
Need Help
smann's avatar
smann
Helper I
8 years ago

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)

    
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi smann,

 

Nope, power bi not support these analysis. Each analysis should be a measure , but current power bi not allow to use measure as axis or row label.

 

Regards,
Xiaoxin Sheng