Forum Discussion
Switch statement to return chat values
yes! thank you so much
One thing, for you to display the CATEGORY level - managers, cats etc etc on the X axis, DAX would need a table that contains those values in a single column.
You can either achieve it by creating a table on-the-fly like I did and have the visual created form table 2 or by creating a disconnected table as DCN in the example and then SWITCH !!!! 😂😂
the reason I wanted to use a switch statement is because I have a lot of other data in my file and I dont want to mess up any other visuals if I were to pivot this data
Does this work for you?
yes! thank you so much
smpa01 I spoke too soon:
is it possilbe to use a switch statement when the data is formatted like this:
Users Salesmembers Managers Cars Phones Expenses pagers 10,205 1,500 500 2,000 2,000 1,503 1,500 not pivoted
As long as the categories in the source data are within a single column the measure will work as planned even if you plan to include those categories as columns in the viz.
But if the categories are separate columns within the source data, they need to be pivoted first to cluster in a single column for you to achieve what you need.
got it. My last question would be is it possible to create a seprate table pulling in only the data i need from the origional table?
meaning only pulling this data:
Users Salesmembers Managers Cars Phones Expenses pagers 10,205 1,500 500 2,000 2,000 1,503 1,500 into a new table so I can pivot
thank you so much for the help