Forum Discussion
Making Switch function return a column in a table and not a measure (PowerBI DAX)
What I'm trying to do is to change measures using slicers in Power BI Desktop. I have found some examples of people who have done that (for instance this ) . What they do is that they create a t...
Hi Anonymous ,
You could use DAX Studio to export all the columns and import the files into Power BI to combine them as one table. Then you could use the columns name in the Switch function.
select * from $SYSTEM.TMSCHEMA_COLUMNShttps://daxstudio.org/documentation/features/
I have a table in power bi name sheet1 and i want to use the columns of that sheet in a new measure for a switch function ,but when i am trying to use sheet1 it is not coming?