Forum Discussion
Calculation Help with growing column
Hi, Another calculation quandry. It'll help if you see a sample first: Release Date: May-18 Months Since Release (M) Fails (F) M x F (May) 5 12 60 (June...
Give a try with this please...
GrandTotal = SUMX(MonthsFails,MonthsFails[Months Since Release (M)]*MonthsFails[Fails (F)])
Thanks. That helps in part. However, is there a method of deriving the months since release without resorting to its own column? Or resorting to columns at all. Ideally, I'd like to have only 2 variables: the release month and total failures. Surely there is a formula that will not require a new table or column.