Add descriptive Statistical measures

[Anonymous]

Is it was possible to create a table that looks like this in PowerBi

	January 2018	February2018	March2018	April2018
Average	10	11	10	9
Median	9	12	8	7
1st Quartile	4	6	5	5

And the data that we have looks like this:

January2018Counts	February2018Coutns	March2018Counts	April2018Counts
3	3	4	4
4	6	5	5
6	7	8	6
9	12	8	7
12	12	10	9
16	17	16	12
20	19	19	17

[v-yuta-msft · Accepted solution]

@Anonymous ,

Firstly, in query editor, click unpivot columns, then you will achieve the Attribute and Value columns. After applied&close, create three measures using dax below:

Average = CALCULATE(AVERAGE('Table'[Value]), ALLEXCEPT('Table', 'Table'[Attribute]))
Median = CALCULATE(MEDIAN('Table'[Value]), ALLEXCEPT('Table', 'Table'[Attribute]))
1st Quartile = CALCULATE(PERCENTILE.EXC('Table'[Value], 0.25), ALLEXCEPT('Table', 'Table'[Attribute]))

The result will be like below:

  

You can also refer to the pbix file.

Community Support Team _ Jimmy Tao

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

[v-yuta-msft · Accepted solution]

@Anonymous ,

Firstly, in query editor, click unpivot columns, then you will achieve the Attribute and Value columns. After applied&close, create three measures using dax below:

Average = CALCULATE(AVERAGE('Table'[Value]), ALLEXCEPT('Table', 'Table'[Attribute]))
Median = CALCULATE(MEDIAN('Table'[Value]), ALLEXCEPT('Table', 'Table'[Attribute]))
1st Quartile = CALCULATE(PERCENTILE.EXC('Table'[Value], 0.25), ALLEXCEPT('Table', 'Table'[Attribute]))

The result will be like below:

  

You can also refer to the pbix file.

Community Support Team _ Jimmy Tao

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

[Anonymous · Accepted solution]

I Used below solution and that helped :

Built the measures needed and put them in the ‘values’ on the matrix along with the date in the ‘columns’. Then selected the setting called ‘Show on rows’ in the values settings on the matrix.