You are viewing a single comment's thread from:
RE: SWITCH Function in DAX for Excel Power Pivot and Power BI
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