Currently, I am exploring the option of using Direct Query instead of the Import option to assess the performance of the model. I am querying a table with 20m rows. For simplicity, let’s assume that the data in the table is tidy and it’s in a good shape, so there is no need to apply transformation (I wish ). I noticed when I try to create a measure (Using SWITCH function in my case) I couldn’t reference the column header? Any ideas as to why I can’t?
SWITCH( Expression(Column),Value1, Value2, …)
Thanks in Advanced.