As Buck Woody notes here, when you are exploring a new data set it can be useful calculate some basic descriptive statistics. One new M function that appeared in Power BI recently can help you to do this: Table.Profile(). This function takes a value of type table and returns a table that displays, for each column in the original table, the minimum, maximum, average, standard deviation, count of values, count of null values and count of distinct values (but no mode or median?).
Tag Archives: Statistics
Report “Inventory – Purch. Statistics”
I developed a report similar to report 712 “Inventory – Sales Statistics” to get a statics for all purchased items grouped by vendor and production group.
Customer Statistics FactBox
The Page 9082 is not displaying correct information. One of the fact boxes for sales is the Customer Statistics factbox page 9082.