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 !!!! 😂😂
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
Anonymous can you please provide me a source data which would have other undesired data and the final output that you desire.
Sure one moment. How can I add a file to this thread ? I dont see where I can drop a file