How to pass multiple value to switch

Question

Hi,&nbsp;I am having multiple measures for each year data.I have a column that has multiple year values, say 2000, 2001, 2002&nbsp;I want get data from measures based for each year in the years column.&nbsp;Help is much appreciated

greg_deckler · Answer

raveenraveen&nbsp;Not sure I understand. You can use either:
SWITCH('Table'[Year],
  2000, &lt;do something&gt;,
  2001, &lt;do something else&gt;
)
or use a SWITCH(TRUE(),...) statement.

raveenraveen · Answer

Hi Greg_Deckler, thanks for the reply.When i passed the table column as expression to switch i got the exception -&nbsp;A table of multiple values was supplied when a single value was expected

greg_deckler · Answer

raveenraveen&nbsp;Wrap it in an aggregation like MAX('Table'[Year])

raveenraveen · Answer

Greg_Deckler&nbsp;Using the aggregation will not check for all the years in the years column right?It will check only for max of year single value.I need to check for all the years value in the column say!-------!&nbsp; Year!-------!&nbsp; &nbsp;2019&nbsp; &nbsp; 2020&nbsp; &nbsp; 2021&nbsp;Yeatbaluemaeusre = Switch( Table[Year])&nbsp; &nbsp;2019, measure1,&nbsp; &nbsp;2020, measure2.

greg_deckler · Answer

raveenraveen&nbsp;I don't think I am understanding your use case. It comes down to context. So, for example, you put your Year column into a table visual as the rows or you put the Year column in a Matrix column as the colums or rows. Thus, in the visual context grabbing the MAX of the Year returns the year in the current context (row or column) and you return your desired measure. If this is not the use case, perhaps you can explain exactly what you are trying to accomplish in terms of the visual configuration.

Forum Discussion

How to pass multiple value to switch

10 Replies

Related content

Runtime Lakehouse Switch between multiple notebooks

Waterfall with multiple values

Multiple switch commands but multiply value for weight

Alternative to SWITCH ()?

SWITCH with Multiple Columns