Forum Discussion
Solved
How to get descriptive statistics for multiple columns
I am working on a data set with couple thousands of rows but with more than 300 columns/variable. Most of the variables are categorical and there some continuous. I need to get descriptive statistics...
Thnak you for such quick response. I added Table Profile but received theis message:
Expression Error: The name "Changed Type" wasn't recognized. Make sure it's spelled correctly.
helalm changed type usually relates to it changing your data types, id have to see your code
in power query maybe just remove that step called changed type?
Here is trhe code:
let
Source = Sql.Databases("99999999999"),
CENCDBST01DEV = Source{[Name="CENCDBST01DEV"]}[Data],
dbo_CENST01_V1 = CENCDBST01DEV{[Schema="dbo",Item="CENST01_01_V1"]}[Data],
#"TableProfiling" = Table.Profile( #"Changed Type" as table) as tablein
#"TableProfiling"
I got it...works great.
Thank you.
helalm great remember to accept solution so others know what the solution was thanks :)