Forum Discussion
Anonymous
4 years agoNot applicable
Custom Summarization - change the summarization expression(Formulae) based on the column type
Hi, I have a table I need to summarize a table in power using own formulas , The table contains two ”Id” columns based on which I need to group by, and for summarizing first I need to check the co...
amitchandak
4 years agoSuper User
Anonymous , Try a measure like
Switch(max(Table[Value1Type])
"Sum", [Sum],
"Avg", [Avg],
"Count", [Count])
Anonymous
4 years agoNot applicable
But I am trying to achieve using GroupBy() or Summarize() dax function , I need the value1 , value2 , value3 columns in one temp table. Is it possible ?