How to refer to a column based on slice value in text format (indirect function from Excel)?

[Sica]

Hello All!!

I have a text value selected through a slice, and I would like to use this selection to refer to a column.

I have the same column (named Value) in different tables, and based on the text value selected using a slice, I would like to select the column Value in the proper table.

Thank you for any ideas,

Simone.

[amitchandak · Accepted solution]

@Sica , I doubt any function like that. You may have to write a switch to choose the required column

How they switched value in this example, you have switch column

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...