Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to create a descriptive satistics table?

Hi everyone! I have a table with some fields - deliveries, sales, forecast and returns - for which I would like to create a table visual showing 3 very basic descriptive statistics: minimum, maximum...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi Anonymous ,

     

    Based on the sample data you provided, I created a test pbix file

    Select the two columns and click unpivot other column.

    Then create the measure according to your requirements and drag them into the matrix.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , You have to create those measures and later split them for visual table like given below

 

Summarize table for formatted tables
	Display Table = union (SUMMARIZE(Sales," Measure", "MTD", "This",[MTD],"Last",[LMTD],"Change",[MOM]),
	SUMMARIZE(Sales," Measure", "QTD", "This",[QTD],"Last",[LQTD],"Change",[QOQ]),
	SUMMARIZE(Sales," Measure", "YTD", "This",[YTD],"Last",[LYTD],"Change",[YOY]))