Forum Discussion
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 including frequency for categorical and measures such as mean, median, std, etc for others. In any statistical packages such as SAS, SPSS, JMP you can just drag and drop as many variables as you want and in one run get the descriptive. Is there a way to accomplish the same in Power BI? any custom visualization are out there that can handle this? The only method that I can think of is to use either R or Python. Any thoughts/suggestions?
Thank You
7 Replies
helalm are you importing the data in if so use profile in power query
http://blogs.adatis.co.uk/callumgreen/post/Replicating-SSIS-Data-Profiling-in-Power-Query
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?