Forum Discussion
lcasey
Post Prodigy
Post ProdigyCreating a new table using summerize
Hello, I have a realy weird calculation that doesnt seem to work. I am creating a new table with 3 columns from an existing table. The new table has 3 columns Revenue Gap - Whole number ...
Hi lcasey ,
including the amount-columns in the columns to aggregate on doesn't seem to make much sense in my eyes. What does the expression return if you omit them like so:
Revenue Gap = SUMMARIZECOLUMNS( Revenue[Campaign Name _x002dId], "Gap",SUM(Revenue[Revenue Gap]), "Revenue",sum(Revenue[Regularization]), "Average" ,DIVIDE(sum(Revenue[Regularization]),sum(Revenue[Revenue Gap])) )
