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 !!!! 😂😂
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
you can share a file through G/1 drive
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 !!!! 😂😂
yes possible
here is the pbix file with the sample data. https://drive.google.com/open?id=1W6IiXgXpEGylUPt-bUIln7uakSDb_Ax6
I cannot pivot the data because i am using the other data for other visuals.
this is what I would like to accomplish :
thank you, this is perfect
smpa01 is it possible to only sumarize the most current date and not all the dates?