Hello!
I am working with making a new measure.
First I wanted to make it a column, but seeing how I'm using a dynamic parameter I have come to understand I need to use a measure instead. The parameter is called Parameter and is a numeric range between 1-500
I have a data table with each row representing a year and a quarter ("YYYYQQ" format). I have a numeric column called "Number". And in the visualisations I want For example a table I want it to look like this (if chosen 20 in the what-if parameter):
| YearQuarter | Number | NumberFactor |
| 2019Q1 | 1000 | 20000 |
| 2020Q2 | 20 | 400 |
(I have come to understand the measure won't be visible in the data tables, but still can be displayed in a table visualisation)
When i write: NumberFactor= Table[Number] * Parameter[Value Parameter] I get the error
" Cannot determine a single value for the column "Number". This can happen when a measure formula refers to a column that contains many values without an aggregation to obtain a single result "
Many thanks for any help!
