Hi @dernan, yes there is a switch function in Excel. I havent yet covered it as a learning blog.
as for the calculated column - you are correct, columns can be used as fields in pivot tables and visulisations whereas measures can not
You are viewing a single comment's thread from: