Hello!
In Excel I want a list of descriptives on multiple columns of a table in the data model. One row for each table column with four columns: column name, value count, min and max values. The data table columns are of different types: text, number and timestamps. Rows are filtered by another column.
My current solution is to define three measures for each column like
Then get the value like
That's a lot of typing. Is there a more comfortable way to do this?
In Excel I want a list of descriptives on multiple columns of a table in the data model. One row for each table column with four columns: column name, value count, min and max values. The data table columns are of different types: text, number and timestamps. Rows are filtered by another column.
My current solution is to define three measures for each column like
Code:
v7_max:=CALCULATE(MAX(table[v7]), table[filtervar]="selected")
Code:
=CUBEVALUE("ThisWorkbookDataModel","[Measures].[v7_max]")
