Forum Discussion
AmaGreen
2 years agoFrequent Visitor
Descriptive Statistics on multiple columns
Hello Community, I have a dataset that I need to perform calculate the average, minimum and maxim based on the specific categories of items. I would like an assistance on how to perform the descri...
Anonymous
2 years agoNot applicable
HI AmaGreen,
You can create a new table with three type of aggregate modes, then you can use it as source of slicer to choose the corresponding calculate mode.
After these steps, you can write measure formula with switch function to check the current selected value and redirect to different calculate expressions.
Regards,
Xiaoxin Sheng