Unpivot the table so that your attribute names are values in a column and not column headers
multiple dynamic measurments including time slicers
Hello,
i want to get the result of multiple measurements in the following way:
result1
result2
.
.
resultx
one single entry is the result of a measurement and depend on a time slicer performed by the Datetable:
result1 = CALCULATE(AVERAGEX('Table1',Attribute1]), ALLSELECTED('Datetable'[time]))
--> a simple moving average calculation based on the dates choosen in Datetable[time]
I cannot put the entries into a table, because of the calculation based on time (timeslicer) and will result in lost of the dynamic calculation.
Unfortunately, I need all results lined up in one column.
If you need more information, let me know.
Thank you in advance!